AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N9452MSoares De Matos Guilherme Cesar · Fort Lauderdale, FLN9452NAlaska Department Of Public Safety · Anchorage, AKN9452UCurtis Marilyn D · Woodland, CAN94531Cire Aviation LLC · Lutz, FLN94532Oklahoma State University · Stillwater, OKFirst renewal noticeN94536Freese Marc A · Fulda, MNN94537Joyner Russell L · Aulander, NCN94538Curran James · Santa Ana, CAN94539Woodward William R · Portland, ORN9453BCain James W · Big Rapids, MIN9453CEarth Center Adventure Inc · Haines, AKN9453THansen Jerry E · San Antonio, TXN9453XFlying Machines LLC · Danville, CAN94544Dawson Farms · Tappen, NDN94549Scott Nathan A · Lake Winnebago, MON9454XRoland Aviation LLC · Saint Matthews, SCN94553Delta State University · Cleveland, MSN9455UUniform Aircraft Holdings LLC · Ransom, ILN9455XRather Be Airborne LLC · Chaska, MNN94569Chester Charter Inc · Chester, CTN9456CCoaker Martin · Ada, MIN9456DMajka Marc · San Carlos, CAN9456XMoxie Holdings LLC · Midvale, UTN94570Richmor Aviation Inc · Hudson, NYN94573Sky West Aviation Inc Trustee · Albuquerque, NMN94577Ace Aircraft Leasing Inc · Nazareth, PAN9457DN1705r Inc · Cobb, CAN9457UClemens Jerry W · Parsons, KSN9457XRoss Karen F · Marion, TXN94584Sale Reported · West Lafayette, INSale reportedN94585Aviation Trade Inc · Castroville, TXN94587Kenny Douglas B · Auburn, NHN94588Burt Lisa C · Justin, TXN94589Haverlock Aircraft LLC · Willoughby, OHN9458TWasp Air LLC · Hamilton, MTN9458XAnderson William B · Rogers, ARN94592Oklahoma State University · Stillwater, OKN94596Koulbou Moussa A · Chandler, AZN94598Klein Thomas Alan · North Pole, AKN94599Ams Aviation LLC · South Bend, INN9459BMiller Jason · Clifton, NJN9459MCivil Air Patrol Inc · Maxwell Afb, ALN945ASA2g International LLC · San Juan Capo, CAN945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN945KMSkypros East Kansas City · Grain Valley, MON945RCR&C Aviation Partners LLC · Tucson, AZN945SMFive Rivers Flight Training LLC · Livermore, CAN945TC R Transport Inc · Wilmington, DEN94608Hansen David A · Milton Freewater, ORN94609Heavy Metal Air LLC · Farmingdale, NY
Back to AD 87-20-03 R2