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.
N2920UOtto Mark A · Ludington, MIN2920VMorrow William M Jr · Harrison, IDN2921Carter Bradford J · Rockland, MEN2921DErlandson Lloyd V · Hilmar, CAN2921JAndrews University · Berrien Springs, MIN2921KDenney Brent A · Fowler, COFirst renewal noticeN2922JStecklein Brittney R · Overland Park, KSN2922SWard Aviation · Marysville, OHN2922VGulf Airbatics Ltd · Jennings, LAN2923DHurd Nathan A · Lisbon Falls, MEN2923SHamann John · Orlando, FLN2923UWeber James · Fall Creek, WIN2924JPiscoya Thomas G · Anchorage, AKN2924NRhoades William P · Northfield, MNN2925HYamron Mark L · Borrego Springs, CAN2925KMurray Gregory T · Napa, CAFirst renewal noticeN2925SSmolik Amanda · Ponder, TXN29261Old Glory Air Corps Inc · Parker, CON29262Darrow Mark · Mukilteo, WAN2926HKrueger Arden B · Wausau, WIN2927UCarlson Brent A · Medford, ORN29288Kluver Richard L · Three Lakes, WIN2928DMatheny Kimberly D · Washington, WVN2928JVu Huy T · San Diego, CAN2928SDoubler Endeavors LLC · Orlando, FLN2928UHeim Christopher J · Beavercreek, OHN2929NPekkala Ross F · Palmer, AKN2929STerrell Aviation Inc · Terrell, TXN2929ULarson Michael J · Canton, ILN292DAIndependence Youth Flying Club Inc · Independence, ORN292NKki Corp · Reno, NVN2930DGuerin Stephen · Lyme, NHN2930JTetil Nicholas M · Fairgrove, MIN2930NDuenas Carlos · Hurricane, UTN2930UWeast Michael D · Artesia, NMN2931JSmith William T · Fort Payne, ALN2931ULudwig Alfred R · Hayward, CAN2932DDont Make Things Difficult LLC · Downers Grove, ILN2932NEsmiol Matthew · Durham, NHN2932SRutoski Mary Ann · Jordan, MNN2933KSciolla Christopher M · Lumberton, NJN2933NWelch Aviation Services LLC · Houston, TXN2933SHarry Kevin M · Salisbury, NCN2934DHennis Jess L · Cottonwood, IDN2934ULison Denis Gregory · Hollis, NHN2935DMorris Mark A · Westlake, TXN2935JSmith Stanley P · Athens, ALN2936DKrish Air LLC · Louisville, KYN2936HHeideman Christopher M · New London, WIN2936JElkins James D · Salem, OR
Back to AD 94-05-05 R1