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.
N15255Elizabeth City State University · Elizabeth City, NCN152BFFlorida State Guard · Tallahassee, FLN152MEChamp Jerry D · Belton, SCN152RFHeritage Aviation Management Ltd · Conroe, TXN152SAXd Aviation LLC · Castle Rock, CON153PCRegistered aircraftN153WMPollard Aviation LLC · York, MEN1544CElite Approach LLC · Chesterfield, MON154HROakes Aviation LLC · Racine, WIN1558QHostettler Aviation LLC · Nashville, TNN156DWAtp Aircraft 2 LLC · Wilmington, DEN156MEArcher III LLC · Littleton, CON157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN157KCNorthwestern Michigan College · Traverse City, MIN157MEMaine Coastal Flight Center Inc · Bangor, MEN157RDBoman & Kemp Lc · Ogden, UTN157SMHumphreys James F · Charleston, WVN157ZZRegistered aircraftN1589DN1589d LLC · Stuart, FLN158JRCollins Stephen Neil · Clancy, MTN158PAndry Holdings LLC · Missoula, MTN158RAJohneco Inc · Beachwood, OHN158SFAlba Leasing Services LLC · Scottsdale, AZN1590WCc Aviation Inc · Tracy, CAN159DRPiedmont Flight Inc · Winston Salem, NCN159FSEastern Kentrucky University · Richmond, KYN159KMHeritage Aviation Management Ltd · Conroe, TXN15ANAb Prop Plane II LLC · Metairie, LAN15EASwanson Blake J · Ketchum, IDN15MJRegistered aircraftN1600UOsprey Holding Company LLC · Foley, ALN1608SNew Horizon Aviation Inc · Warwick, RIN160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORN160TTStraightline Private Air LLC · Denver, CON1615AAnson Air LLC · Sugar Land, TXN161CSAlberco LLC · Lovell, MEN161SPCalifornia Department Of Parks And Recreation · Mcclellan, CAN16237Main Line Assets LLC · Wayne, PAN162CPCivil Air Patrol · Maxwell Afb, ALN162CSFrielingsdorf Tim Richard · Manvel, TXN162JKAlf Ix LLC · Chicago, ILN162MEIasco Flight Training Inc · Redding, CAN162TCDrummond E Garrison · Parksley, VAN163CPCivil Air Patrol · Maxwell Afb, ALN163JBBender W Jeffrey · Ocala, FLN163MEAircraft Owners And Pilots Association Inc · Frederick, MDN1641CCe-172 Aircraft LLC · Wilmington, DEN1643CCe-172 Aircraft LLC · Wilmington, DEN1646CCe-172 Aircraft LLC · Wilmington, DEN1648CCoast Aviation LLC · Costa Mesa, CA
Back to AD 2000-04-01