AD 94-05-05 R1
Registered aircraft · 26,232
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.
N5675GGray Mark J · Muncie, INN5675RN5675r Corp · Rochester, NYN5675TPhillips Michael · Thompson Falls, MTN5676ALakes Area Aviation LLC · Little Falls, MNN5676CStearman John T · Collinsville, OKN5676FBrad S Jones LLC · Oak Hill, FLN5676GSchmidt Gary L · Afton, MNN5677FFarmer Jim D · Savannah, MON5677GFredenburg Justin N · Edgeley, NDN5678ABailey David D · Twentynine Palms, CAN5678FGregory Vernon L · Swansea, SCN5679ALeblanc Kenneth E · Franklinton, LAN5679FLong Mark B · Wichita, KSN5679TCataneda Jose · Yakima, WAFirst renewal noticeN567ECStaudacher Mark W · Bay City, MIN567GSFlying R LLC · Spokane Valley, WAN567JMMartinez Ivan C · Sugar Land, TXN567PSSlay Philip L Trustee · Bossier City, LAN5680AMoore John W · Salome, AZN5680EBenway Peter S · North Salem, NYN5680PHaro Roger E · Eden Prairie, MNN5680RBraun Joshua H · Springfield, MON5681AKiesow Arthur W · Agua Dulce, CAN5682ANewbury Arnold E · Phillips, WIN5683CBaker Mark A · Orangeville, ILN5683FBrady Robert M · Shawnee, KSN5683RLewis George H · Brookline, NHN5684AGirard Richard J · Somerset, MAN5684ETucker Lawrence J · Emporia, KSN5684FRegistered aircraftN5684RGorton Horace B · Overland Park, KSN5684TStahl Adam Charles · Fort Wainwright, AKN5685FRailton Joseph · Wadesboro, NCN5685THolland Bruce B · Mansfield, TXN5686FElling Jerrold A · Ladysmith, WIN5686RLogan Kevin · Amarillo, TXN5687EWitter Jaykob J · Greenville, MIN5687GChilders Roderick G · Red Banks, MSN5687REsch Randall L · Stanton, MIN5687TSchultz Josh · Blanchard, OKN5688ASutton Aircraft Salvage LLC · Palmer, AKN5688EWagner Bryson R Jr · Lewistown, PAN5688GFriends Of Jesus · Poughkeepsie, ARFirst renewal noticeN5689AAffordable Aircraft LLC · Bellevue, MIN5689FCarrell William G · Pittsburgh, PAN5689MKilo Mushroom Aeronautics Inc · Bellevue, WANon-citizen corporation, flight hours not reportedN5690RMcveigh Ian Thomas · Mansfield, TXN5690TJohnson Clinton A · Haughton, LAN5691CDalton Bart · Owasso, OKN5691FBahm Martin P · Edmond, OK
Back to AD 94-05-05 R1