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.
N22LJWolgat Alexander M · White Lake, MIN22NKTitcomb Isaac Stephen · Deland, FLN22VERegistered aircraftN22WTGarcia Roberto P · Spring Hill, FLN22XFMassel Stephen E · Edgewater, FLN22XXHeath Michael A · Barnet, VTN22ZCMarker Michael M Jr · Los Lunas, NMN23001Henshaw Edward C · Vian, OKN23009Hopkins Francis · Wilmington, DEN2300DEmbry Aero Ltd · Greenville, ILN2300VClay Ernest P · Huntington, WVN23012De La Fuente Carlo H · Lompoc, CAN23015Schalk Rudolph A · Morgan Hill, CAN23017Kopacz Keith P · Saint Thomas, VIN23018Andrews University · Berrien Springs, MIN23025John R Roberts Jr · Homestead, FLN23027Stapleton Jerry L · Jacksonville, FLN2302HEnigma Aircraft LLC · Benton Harbor, MIN2302KHartman Alfonse A · Mc Alpin, FLN2302NAnimal Eye Clinic Of Pensacola LLC · Pensacola, FLN2303DDemar Aviation LLC · Spotsylvania, VAN2303UMurtha John P · Baldwin, WIN23046Thomas Jaclyn L · Carrollton, OHN2304EHeitz John · Manvel, TXN23051Gradle Roger Thomas · Fairhope, ALN23056Veltman Ine · Mayodan, NCN23059Smoketown 150 Club LLC · New Holland, PAN2305BDoyal William T · Visalia, CAN2305DKupchak Bruce · Bridgeville, DEN2305KScimone Michael J · Wildwood, MON2305VN2305v LLC · Grand Haven, MIN23064Cherry Creek School District No #5 · Greenwood Village, CON23068Pike Mark D · Victorville, CAN2306BBandrowicz Leon A · Lindenhurst, NYN2306KSchlosser Joseph V · Rockford, MNN23070Building Busters Demolition & Excavation Corp · Saint Louis, MON23076Alvarado Victor A · Douglas, AZN2307BMoyer Alan L · Perkasie, PAN2307DSunderland Paul · Savannah, GAN2307EAbel Brandon R · Henderson, NVN2307KStory Jeffrey A · Colorado Springs, CON2307UCowgar Jeremy N · Norton, OHN2307VKarel Benjamin R · Stillwater, MNN23083Gilstrap Stanley C · Inola, OKN23085Flightwave 77 LLC · Dearborn Heights, MIN2308UMarsh Hank K · Joseph, UTN2308VInverted Aero LLC · Spring Hill, FLN23096Pilot Pros Inc · Miami, FLN23098Saddler Darrell L · Elk City, OKN2309VDahlke Philip H · Smyrna, GA
Back to AD 94-05-05 R1