AD 2002-03-52
Registered aircraft · 1,115
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N213PFLapd Air Support Division · Los Angeles, CAN214EHBristow LLC · Lake Charles, LAN214GHCobalt Holdings Inc · Pacoima, CAN214STBank Of Utah Trustee · Salt Lake City, UTN215EHBristow LLC · Lake Charles, LAN215GHBase Camp Aviation LLC · Mccall, IDN216CHCoastal Helicopters Inc · Juneau, AKN216EHBristow LLC · Lake Charles, LAN2171CNs Air Leasing LLC · Wilmington, DEN217EHBristow LLC · Lake Charles, LAN217FDBristow LLC · Lake Charles, LAN217HPNs Air Leasing LLC · Wilmington, DEN218SHSuperior Helicopter Services LLC · Indianapolis, INN21FYH125 Aviation LLC · Wailea, HIN220CFMercy Air Helicopter Inc · Fort Lauderdale, FLN221LALapd Air Support Division · Los Angeles, CAN221MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN221PAFa Aviation Logistics Inc · Houston, TXN223LALapd Air Support Division · Los Angeles, CAN223MTMed-Trans Corp · Denton, TXN224LALapd Air Support Division · Los Angeles, CAN224MTMed-Trans Corp · Denton, TXN225LALapd Air Support Division · Los Angeles, CAFirst renewal noticeN226LALapd Air Support Division · Los Angeles, CAFirst renewal noticeN226MTLendingclub Bank Na · Boston, MAN226PDAnaheim Police Dept · Fullerton, CAN227MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN227NDHillsborough County Sheriff · Tampa, FLN227TXTexas Department Of Public Safety · Austin, TXN228LACity Of Los Angeles · Los Angeles, CAN229AHMiller Jason · Scottsdale, AZN229LACity Of Los Angeles · Los Angeles, CAN229MTMed-Trans Corp · Denton, TXN230AHAir Methods LLC · Greenwood Village, CON230LALapd Air Support Division · Los Angeles, CAN232LACity Of Los Angeles · Los Angeles, CAN232SHJc Aircraft Leasing LLC · Wasilla, AKN233LACity Of Los Angeles · Los Angeles, CAN233PAComanche Maverick Air LLC · Houston, TXN234BHBrainerd Helicopters Inc · Leesburg, FLN234BUHeli-USA Corp · Houston, TXN2374FTexas Department Of Public Safety · Austin, TXN237BSSky High Leasing LLC · Montrose, CON239AHAirbus Helicopters Inc · Grand Prairie, TXN23HSVertical Corp · Kalispell, MTN242ADepartment Of Homeland Security · Washington, DCN243GCGranite Coast Mapping · Coronado, CAN244CPAircraft Trustee Services Inc Trustee · Dover, DEN244TXBrenthel Industries LLC · Helena, MTN245AMAir Methods LLC · Greenwood Village, CO
Back to AD 2002-03-52