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.
N1652YWallitner Matthew M · Oroville, WAN1653BMays John Robert · Port Saint Joe, FLN1653FN1653f LLC · Miami, FLN1653QDust Devil Weekend Warriors LLC · Ridgecrest, CAN1653YBarua Dennis · Midland, TXN1654NMaxfield John O · Canton, MIN1655DAcosta Antonio A · Campbell Hall, NYN1655FRoughcreek Aviation LLC · Thomas, OKN1655NScheufler Mark E · Seven Bays, WAN1656FParagon Aviation LLC · Reading, PAN1656VCobb Raymond E · Highland, CAN1657DFlying Aces LLC · Scappoose, ORN1657FZaleski James A · Bonsall, CAN1657YPegasus Aviation LLC · Rogersville, MON16585Alegre Richard E · Ventura, CAN1658DClement Aircraft LLC · Anchorage, AKN1658FMondo Beyondo Thrill Squadron · Pasadena, CAN1658PSmith Gregory · Lewistown, MTN1658QHis Kingdom Aviation · Nevada, TXN1658YYankee LLC · Casa Grande, AZN1659QFlying Wings Of Lousiana · Denham Springs, LAN1659YCrosswhite Noel A · Cabool, MON1659ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYN165FCPocono Mountains Flying Club Inc · Tobyhanna, PAN165LADicairano Gerard J · Salisbury, MDN1660EVia Johnnie W · Atascadero, CAN1660QDulitz David E · Webster, SDN16612Grant William G · Almont, MIN1661EWalts Byars · Annandale, MNN1661FSharp Gary · Rigby, IDN1661VWeggel Roger · Fairbanks, AKN1661YRegistration Pending · Cowpens, SCRegistration pendingN1662ECalifornia Antique Aircraft Museum DBA · San Martin, CAN1662VLauer Donald Robert · Prospect, OHN1663FSixtree Foxy Blue LLC · Renton, WAN1663QJohnson Steven · Cheyenne, WYN1663VBryant George R · Gainesville, TXN1664DScud Air Solutions LLC · South Weber, UTN1664EJatho Jimmy W · Augusta, GAN1664FGrace Christopher L · Mooresville, NCN1664QWithrow Steven D · Lubbock, TXN1664YOleary Joseph · Richmond, VTN1665DDinstel Delbert F · Park City, MTN1666Bishop Aviation Inc · Decatur, TXN1666EBelanger Paul L · Westbrook, MEFirst renewal noticeN1666QRegistration Pending · Plymouth, MNRegistration pendingN1667FVarner Properties LLC · Bristow, OKN16686Smith A J · Oneill, NEFirst renewal noticeN1668EDehn-Reynolds Mary M · Searsport, MEN1668QBrunk Hubert J · Lincoln, NE
Back to AD 94-05-05 R1