AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8493XDavis Michael L · Rowland, NCN84949Echenique Frank Joe · Bakersfield, CAFirst renewal noticeN8494GReynolds Terry J · Phoenix, AZN8494URieck Brian M · Junction, TXN8495GCorrigan John P · Denver, CON8495JParks Ryan Alan · Newcastle, WYN8495XRomeoromeo Alpha LLC · Greensburg, INN8496UChandler Donald M · Alexandria, LAN8496XR & R Flight Services LLC · Orange Grove, TXN8497GDeacon Jeffrey A · Battle Ground, WAN8497MWenatchee Valley Barnstormers LLC · Wenatchee, WAN8497URawlins Flying Club Inc · Rawlins, WYN8497XConnors James R · Manchester, MIN8498BHoeft Brian K · Stratford, SDN8498XThompson Jason Edward · River Heights, UTN84999Boynton Rodney B · Ocala, FLN8499GRyan Richard E · Atlantic, IAN8499XSkaggs Nathan H · Peebles, OHN849XLChurch Niley M · Wichita Falls, TXN84BCBerglund Mark · Rockwall, TXN84CCBowman Gregory H · Wichita, KSN84JK Diamond K Guest Ranch LLC · Republic, WAN84LMurrey James E · Pulaski, TNN84RCLankford Philip S · San Marcos, CAN85009Kepler Justin W · Nikolaevsk, AKN8500GAugust Mark C · Atchison, KSN8500JRiley Alfred E III · Norristown, PAN85018Dugger Richard · Early, TXN8501UOverbaugh Gary R · Highland, UTN85027Obritsch Monte R · Malcolm, NEN8502BSims Hollow M · Lithonia, GAN8502USmitty 172 LLC · Rockford, MIN85033Hardaway Michael R · Springville, CAN8503GPynn David W · Gasport, NYN8503UCropley Alton I · Sitka, AKN85049Shipman Jesse L · Honey Grove, TXFirst renewal noticeN8504UDoug & Holly Harmon Inc · Fremont, MIN8505BGreen James S · Slaton, TXN8505JKunz Isaac A · Texarkana, TXN8505USilverman Phillip E Trustee · Fullerton, CAN8505XBerri Edward W Jr · N Fort Myers, FLN85065Wade Timothy K · Roanoke, TXN8506BTierney Garrett J · Manorville, NYN8506GNighthawk Air Systems Inc · Miami, FLN8506JHorning Richard H · Galion, OHN8506XBugli Zachary J · Stevensville, MTN8507GCaldera Michael E · Williamsport, PAN85087Mathews Scott P · Draper, SDN85089Cattron Matthew · Webster, NYN8508BCc Motors LLC · Redding, CA
Back to AD 94-05-05 R1