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.

N15255Elizabeth City State University · Elizabeth City, NCBuilt 2007 · S/N 172S10455N152BFFlorida State Guard · Tallahassee, FLBuilt 2015 · S/N T20609201N152MEChamp Jerry D · Belton, SCBuilt 2000 · S/N 18280723N152RFHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609611N152SAXd Aviation LLC · Castle Rock, COBuilt 2013 · S/N 172S11275N153PCRegistered aircraftBuilt 2009 · S/N 172S10956N153WMPollard Aviation LLC · York, MEBuilt 2018 · S/N T20609558N1544CElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8365N154HROakes Aviation LLC · Racine, WIBuilt 2007 · S/N T20608755N1558QHostettler Aviation LLC · Nashville, TNBuilt 2017 · S/N T20609516N156DWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 172S8342N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435N157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20608228N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646N157SMHumphreys James F · Charleston, WVBuilt 1998 · S/N 18280157N157ZZRegistered aircraftS/N 18280402N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255N158JRCollins Stephen Neil · Clancy, MTS/N 18280051N158PAndry Holdings LLC · Missoula, MTBuilt 2008 · S/N 20608306N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805N158SFAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 172S10368N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816N159KMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609606N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333N15MJRegistered aircraftBuilt 2024 · S/N 172S13005N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440N160TTStraightline Private Air LLC · Denver, COBuilt 2017 · S/N T20609505N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910N161CSAlberco LLC · Lovell, MEBuilt 2013 · S/N T20609101N161SPCalifornia Department Of Parks And Recreation · Mcclellan, CABuilt 2021 · S/N T20609667N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912N162CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13489N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192N162JKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13466N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715N163MEAircraft Owners And Pilots Association Inc · Frederick, MDBuilt 2000 · S/N 172S8444N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754N1646CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11729N1648CCoast Aviation LLC · Costa Mesa, CABuilt 2016 · S/N 172S11678
Back to AD 2000-04-01