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.
N9928CTaylor Steven E · Mechanicsburg, PAN9929CWildcat Ventures LLC · West Lebanon, NHN9929YMiller William A · Williamson, GAN992BPWhitcomb Glenn R · West Richland, WAN99306Kemper Joseph C · Coxs Mills, WVN99309Sheridan Joshua M · Janesville, WIN9930ASmith David J · Duluth, MNN9930CRoach Stephen W · Glen Saint Mary, FLN99315Shackleford Larry D · Southmont, NCN9931ARowland Brett D · Wichita, KSN9931CKessler Garry A · Lansing, WVN9931YWillis James R · Ocala, FLN9932CAnderson Andrew A · Bates City, MON99339Coe Patrick K · Bellingham, WAN9933ATravelair Inc · Ocala, FLN9934CFinger Terry J · Rockford, MIN9934GDiorio Christopher J · Melba, IDN9935AMichael Monte E · Axtell, TXN9937AInternational Air Services Inc Trustee · Carson City, NVN9937BHolliday Mark E · Lake Elmo, MNN99387Hobschaidt Kurt · Pittstown, NJN9938CDupea Vincent P · Lilliwaup, WAFirst renewal noticeN99399Adams Thomas D · Marathon, NYN9939CKozak Joel L · Long Beach, CAN99402Sidusky Judy A · Queensbury, NYN99405Rathe Don A · Fort Mohave, AZN99406Bahm Martin P · Edmond, OKN9940CGriffin Contracting Co · Bloomfield, MON99411Wido Mark · Plainfield, ILN9941CWatson Bobby · Hoxie, ARN99421Wilhelm Kenneth H · Helena, MTN9942CMiller Steve L · Naperville, ILN99439Wittco Aero LLC · Vancouver, WAN9943ASipple Ronald W Jr · Gardner, KSN99448Howe Larry G · Florence, ORN99451Dietz Carroll F · Rockford, ILN9945CBrouwer Annemarie · Austin, TXN99462Hattel Arthur L · Huntingdon, PAN99463Myers Kenneth O · Niskayuna, NYN99477Masterman Julayne A · Muncie, INN9947DHanshew Steve B · Leesburg, OHN9948AHoatson Larry · Yucaipa, CAN99493Beem Ray M · Apison, TNN99494Eaa Chapter 1590 Inc · Morrilton, ARN99495Southern Aircraft Consultancy Inc Trustee · Casper, WYN9949CDexter Fred H · Live Oak, FLN994JPHinen Paul H · Soap Lake, WAN994NACurry Lloyd F · Karnack, TXN99506High Plains Flying LLC · Burlington, CON9950AHilbert Lee D · Hampton, NJ
Back to AD 94-05-05 R1