AD 2002-16-26
Registered aircraft · 554
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-16-26')
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-16-26')
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-16-26') 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-16-26') 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.
N390GLSidlinger Computer Corp · Flagstaff, AZN394USWings Over Texas Holdings LLC · Denton, TXN396SFunfsinn John J · Peru, ILN398CDBarnes Ralph R · Cocoa, FLN398RCChristopherson Rodney V · Williamsburg, MIN3993Registration Pending · Fort Worth, TXRegistration pendingN400PZAerotech Aviation LLC · Sidney, OHN400SPKaplan Asher H · Tucson, AZN401HAKitty Hawk Flight School LLC · Nags Head, NCN402EDCason Sean R · Bryson, TXN402HAKitty Hawk Flight School LLC · Nags Head, NCN4058UEliasen Anthony J · Carthage, MON405CHGleason William J · Coudersport, PAN406WSMorris Milton L · Pierre, SDN409JDStern Robert J · Alpine, WYN40PBExtreme Air LLC · Santa Barbara, CAN41089Rodewald Ryan · Umatilla, FLN410TMCass Brian O · Raleigh, NCN412PLFischer Joachim W · Foothill Ranch, CAN413FJefts Larry G · Kunia, HIN414RHCity Of Tomball · Tomball, TXN41534Tat Networks And Aviation LLC · Bend, ORN416MGSportflight Inc · Laporte, INN418JGJordan Kenneth L · Grants Pass, ORN419PLHirschi Stephen T · Vernal, UTN422KCWade Karen H · Eloy, AZN423CBHelle Donald D · Chandlersville, OHN425PMMcwhirter Paul · Lafayette, CAN4269GMoon Shannon M · Catawba, NCN4275URobinson Ronda R · Livermore, CAN429RWDzyne Technologies · Foothill Ranch, CAN430WSWind Mountain Aviation LLC · Stevenson, WAN432DKDunnagan Steven A · Little Rock, ARN432WSHuie John E · Burnet, TXN434YDRegistration Pending · Manchester, KYRegistration pendingN43615Baker Franklin E · Montgomery, ILN4362CEdson Larry A · Kettering, OHN4381GDuda Edward F · David City, NEN43889Olson Perry D · Fort Lupton, CON438WFFuller Wm Douglas · Boise, IDN4422Transnational LLC · Arlington, TXN4449Cunningham Richard E · Lafayette, CAN444RQOtteson Ralph · Manteca, CAN445FPFreer James M · Evergreen Park, ILN445RAWeatherly Lloyd W · Wittmann, AZN4462JSmith Douglas E · Trotwood, OHN448JWWilliams John T Trustee · Redlands, CAN44ARMelech John Daniel · Nevada, MON44TNMoore Aviation LLC · Cedar Springs, MIN452KFHildebrand Russell W · Chandler, AZ
Back to AD 2002-16-26