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.

N123GG150th Aero Flying Club · Morristown, NJBuilt 2004 · S/N 172S9600N123PBTextron Aviation Inc · Wichita, KSS/N 172S13648N123PFJet Air Inc · Iowa City, IABuilt 1999 · S/N 172S8086N123VKAtp Aircraft 1 LLC · Wilmington, DEBuilt 2006 · S/N 172S10121N12419Fort Wayne Aircraft LLC · Fort Wayne, INBuilt 2006 · S/N 172S10306N1242BMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10307N1242NBg-Ip LLC · Saratoga, CABuilt 2006 · S/N 172S10309N124CKChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9808N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315N124HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9632N124LLLyonfish Aviation Holdings LLC · Wellington, FLBuilt 2022 · S/N T20609703N124MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8372N124PLL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8194N124WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12393N1250KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13050N12522Island Root Aviation LLC · West Palm Beach, FLBuilt 2006 · S/N T20608671N1252EStedje Timothy M · Gruver, TXBuilt 1999 · S/N 18280580N1254DAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10127N1258FRsns LLC · Snowflake, AZS/N T20608674N125ALNby Productions · Bristow, VABuilt 2021 · S/N T20609639N125LFHubbard Capital LLC · Nashville, TNBuilt 2023 · S/N T20609729N125LGWheat Travis W · Henderson, NVS/N 18280070N125MDMaryland Aviation Administration · Bwi Airport, MDBuilt 2000 · S/N 20608099N125TWSmith Susan · Scottsdale, AZBuilt 2023 · S/N 172S13023N125WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12303N125WWRegistered aircraftBuilt 1998 · S/N 18280348N1260KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13053N1261Evy Holdings Inc · White Marsh, MDBuilt 2006 · S/N 172S10322N126AAAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10076N126AVN106ka LLC · Manassas, VAS/N 172S10621N126BSCape Island Aviation LLC · Millville, NJBuilt 2017 · S/N 172S12012N126HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9053N126MEGlobal Flight Training Solutions Inc · Immokalee, FLFirst renewal noticeS/N 172S8378N126SPPilling Stephen · Southport, NCBuilt 2005 · S/N 172S9796N1270KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13057N12730Silver Creek Aviation Services · Fort Worth, TXBuilt 2007 · S/N 20608302N1276AAir Land Ventures 3 LLC · Berwyn, PABuilt 2007 · S/N T20608794N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532N127JEGillian Michael · Batavia, ILBuilt 2006 · S/N T20608678N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457N1296MThacker Thomas L Trustee · Hurricane, UTBuilt 2008 · S/N T20608803N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825
Back to AD 2000-04-01