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.
N2996HWestlund Steven G · Belleville, ILN2996JDziadaszek Daniel J · Yemassee, SCN2996SKingdom Air Corp · Sutton, AKN2997UWilliams Michael L · Skaneateles, NYN2998DElite Aircraft Sales LLC · Searcy, ARFirst renewal noticeN2999DRegistered aircraftN2999SZheng Zheng · Walnut, CAN2999URichmor Aviation Inc · Hudson, NYN299CBSale Reported · Clovis, NMSale reported, canceledN299DWWebb Douglas C · Mullica Hill, NJN299MWAbramovich Michael Pavel · Scottsdale, AZN299SLSatermo Lee J · New Town, NDN299TDBrueggen Erin J · Cashton, WIN29BHShearer Glendon E · Wall, SDN29BMMclendon Bobby Lee · Escondido, CAN29CVValade Charles T · Tucson, AZN29DFKisthard James A · Roberts, MTN29FFBriggs Aviation LLC · Virginia Beach, VAN29JKGrenfell Henry James · Loris, SCN29LMOlson Kent D · Paxton, NEN29SXTheissen James D · Martinez, GAN2BFMs Aero Inc · Lakeville, OHN2CRSolis Dan · San Francisco, CAN2EFZuber Robert W · Culver, ORN2GFMchugh Donald Edwin · Pflugerville, TXN2JHReign Air Charter Corp · New Port Richey, FLN2KTCambridge Valley Flying Club Inc · Shusann, NYN2LJHouton Fred L · Dublin, GAN2LMCollins Cody W · Palestine, TXN2NMMayberry Harold M · Bryant, ILN2RYEaa Aviation Foundation Inc · Oshkosh, WIN2TAMontgomery Keith L · Florence, ALN2TPHanchett James R · Cheboygan, MIN2TRRussell Thomas P · Milo, MEN2XPNoll Michael J · Albany, MNN2ZZDel Carlo Gary · Tracy, CAN3000GSheets Bruce E · Brooklyn, NYN3000UMerrell Warren W · Idalou, TXN3001GReed Bryan K · Oakdale, NEN3001NWilson Richard W · Independence, ORN3001UPrairie Flyers · Rocky Ford, CON3003HAnderas Per R · Green Bay, WIN3003JCoastal Valley Aviation · Santa Maria, CAN3003XAero Flyers LLC · Stephenson, VAN3004ABaan Richard J · Live Oak, FLN3004GSmith Todd Allen · Belleview, FLN3005AMarquiss Merritt L · Gillette, WYN3005EOctagon Corp · Lewes, DEN3005GParker Joy M · Springfield, MON3005SSpennato Peter Jr · Rolling Hills, CA
Back to AD 94-05-05 R1