AD 2000-04-01
Registered aircraft · 5,676
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:2000-04-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-01')
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:2000-04-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-01') 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.
N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYN136VUPerformance Aircraft Sales Inc · Lincoln, NEN13709Personal Wings Inc · San Diego, CAN1377SUniversity Of Michigan Flyers Inc · Ann Arbor, MIN137CPCivil Air Patrol · Maxwell Afb, ALN137MACivil Aviation Inc · Waukesha, WIN137MEChristiansen Aviation LLC · Wilmington, DEN137PFerguson Frampton Z · Furman, SCN137RJUaa International Inc · La Verne, CAN137TSArk Aviation LLC · Moncks Corner, SCN137VUPerformance Aircraft Sales Inc · Lincoln, NEN138MEA&R Aero LLC · Sacramento, CAN138UDAb Prop Plane II LLC · Metairie, LAN13974Total Prf LLC · New Smyrna Beach, FLN13986Euro 2000 Inc · Merritt Island, FLN139METotal Flight Aircraft Leasing LLC · Apex, NCN139RABeach Cruisers LLC · Ormond Beach, FLN139SAMississippi Forestry Commission · Pearl, MSN139TWMcghee James Allen · Houston, TXN139UDAb Prop Plane II LLC · Metairie, LAN13HNAb Prop Plane II LLC · Metairie, LAN13WNRegistered aircraftN14008Suburban Air Corp · Castro Valley, CAN1400HAmeriflyers Of Texas Inc · Addison, TXN1403RMy Way Aviation LLC · Weston, FLN1407DFlight Training Aircraft LLC · Wilmington, DEN1408BIasco Flight Training Inc · Redding, CAN140CACivil Air Patrol · Maxwell Afb, ALN140RADenome Vincent G · Tampa, FLN140SUOhio State University · Columbus, OHN140UDAb Prop Plane II LLC · Metairie, LAN1410EGulf Atlantic Airways Inc · Gainesville, FLN1416WGulf Atlantic Airways Inc · Gainesville, FLN1418ABay Ronald · Hunt Valley, MDN1419DAir America Flight Center LLC · Daytona Beach, FLN1419FAir Callahan LLC · Bonita Springs, FLN141AAHeavy Metal Air LLC · Farmingdale, NYN141CPCivil Air Patrol · Maxwell Afb, ALN1422CChristiansen Aviation LLC · Wilmington, DEN1422JCareer Track 2 LLC · Wilmington, DEN1423WMaricopa County Sheriffs Office · Phoenix, AZN142BSChristian Tax Advisors LLC · Houston, TXN142CFArq Aviation LLC · Wilmington, NCN142UDAb Prop Plane II LLC · Metairie, LAN1433CChristiansen Aviation LLC · Wilmington, DEN1433SIntrepid Air Services LLC · Raleigh, NCN143GBDocinator Aviation LLC · Edmond, OKN143GMNby Productions · Bristow, VAN143GSPxw Services · Bristow, VAN143MEGateway Of Sturgis LLC · Sturgis, MI
Back to AD 2000-04-01