AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N2497YSouth Plains Precision Ag · Plainview, TXN2498CClark William · Easton, MON2498LJohn Kit M · Shoshone, IDN2498NReynolds Brent · Marietta, GAN2498URegistration Pending · Royal, ARRegistration pendingN2498VFountain John Harrison · Willis, TXN2498YBargabos Earthworks Inc · Peterboro, NYN2499KWellmon Glenn E · Dallas, TXN2499YTompos Michael J · Mendota Heights, MNN249MCTharp Angela K · Wentzville, MON249XEvans James · Tuolumne, CAN24BWHanson Michelle C · Anchorage, AKN24KPBurlak David M · Waverly, VAN24LEHarris Darrel F · Wheatland, WYN24QBFedorko Daniel J · Saylorsburg, PAN24RRFear Barry G · Harrison, OHN24SGVogel Scott A · Dewey, AZN25006Fisher Andrew J · Benton, KSN2500C2500 Charlie LLC · Wilmington, DEN2500HNabb Andrew W · Mooresville, NCN2500KSchroder John Ted IV · Walnut Creek, CAN2500LRice Nancy Kay · Leesburg, TXN2500QSaydun LLC · Richardson, TXN2500XHolloway James H · Merritt Island, FLN2500YSutton Aircraft Salvage LLC · Palmer, AKN2501AEgmond Aircraft LLC · Lewes, DEN2501BGoodrich Jeffrey W · Slaton, TXN2501CLloyd Peter M · Walnut Creek, CAFirst renewal noticeN2501FAerowood Aviation LLC · Monroe, NCN2501JDemaris Darryl G · Baton Rouge, LAN2501KKnudson Eric C · Bozeman, MTN2501ULarkin Edmund V · Bogart, GAN2501VWherry Patrick J · Goodyear, AZN2502BVink Jason M · Palmer, AKN2502FDexter Fred H · Live Oak, FLN2502HHaas David P · Bixby, OKN2502JMartin Clair L Pesonal Representative · Wasilla, AKN2502YSkinner Norman D · Osceola, IAN2503ARegistered aircraftN2503FSuperior Food Distributors LLC · Naples, FLN2503JSmith Coyt B · Benton, ARN2503KMcfall Robert Leroy Trustee · Topeka, KSN2503YGutierrez Gilberto · Lindsay, CAN2504CHain Walter J · Mchenry, ILN2504JGodinez Mauricio U · San Diego, CAN2504KRegistration Pending · Menlo Park, CARegistration pendingN2504LRogers Carol J · Hampshire, ILN2505LCannon Jason P · La Verne, CAN2505NPeterson Todd D · Bonfield, ILN2505VNelson Brian D · Hobbs, NM
Back to AD 94-05-05 R1