AD 2002-07-01
Registered aircraft · 3,466
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-07-01')
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-07-01')
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-07-01') 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-07-01') 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.
N43MEEvans Matthew B · Granbury, TXN4414RKirk Ledoux · Stanwood, WAN4422NValiair Lc Trustee · Casper, WYN4429ETwo Niner LLC · Portola Valley, CAN4429LShingebiss LLC · Independence, ORN442GRAk Air Leasing LLC · Homer, AKN4441WHodge Henry D Jr · Anchorage, AKN44475Jerryair Ltd · Kent, OHN444BSSiemens Christopher L · Seminole, TXN444CLK G L Aviation Inc · Villisca, IAN444FRegistration Pending · Auburn, CARegistration pendingN444PJWagner Aviation LLC · Laura, OHN444RWBackus Gary Carl · Chesapeake, VAN448AKN448ak LLC · Helena, MTN448BBHawkflight LLC · Sugar Land, TXN44CCoyne Greg · Hondo, TXN44CFFly Low Aviation LLC · Smithville, MSN44ECN44ec LLC · Caddo Mills, TXN44EEEchemann Thomas A · Sidney, OHN44FATemple Craig A · Fort Lauderdale, FLN44HRCardinal Aviation Services LLC · Castle Rock, CON44NTTucker Nicholas B · La Canada, CAN44WHKelly Sean R · Bozeman, MTN4500KEaston Gregory D · Montrose, CON450CSCbcb Aircraft LLC · Colfax, WAN450SCSky West Aviation Inc Trustee · Albuquerque, NMN450SEAok LLC · Omaha, NEN4522KGoodman Jack A · Memphis, TNN453MCMcneil Kenneth A · Fort Meade, FLN454GGAk Air Leasing LLC · Homer, AKN454SVEcliax LLC · Craig, AKN4561VOrca Wealth Management LLC · New Port Richey, FLN456BRPressurized LLC · Sequim, WAFirst renewal noticeN456BWCustom Wholesale Supply Co Inc · Odessa, TXN456CWSale Reported · Fort Denaud, FLSale reportedN456MADean Insurance Agency Inc · Crockett, TXN4570KHead East Aviation LLC · Geneseo, ILN4576KPope James Dean · Lewiston, IDN4580KHarrah Daniel R · Juneau, AKN458DJSurvey America Inc · Rancho Cordova, CAN4594CSt Johns Aviation LLC · Saint Johns, MIN4596URustair Inc · Anchorage, AKN45XDSubstation Air LLC · Midvale, UTN4600UDlw Aviation LLC · Missoula, MTN4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLN4601WMike Papa LLC · Newton, KSN4604QBas Part Sales LLC · Greeley, CON4605QRichs Air Service · Victoria, KSN4607QSerrano Lynn A · Casa Grande, AZN4608CTrinity Property Management LLC · Corvallis, OR
Back to AD 2002-07-01