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.

N105HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8724N105LULynn University · Boca Raton, FLBuilt 2005 · S/N 172S9774N105NRState Of Minnesota · Grand Rapids, MNBuilt 2024 · S/N T20609780N10624Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9825N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431N1068YTextron Aviation Inc · Wichita, KSS/N T20609869N106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2001 · S/N 17281055N106EDEdwards Aero Club · Edwards Afb, CABuilt 2000 · S/N 172S8486N106ETFairmont State University · Fairmont, WVBuilt 2000 · S/N 172S8563N106NKMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11156N106RAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8241N106VKLumion Aviation LLC · Mountain View, CABuilt 2002 · S/N 172S9051N1071Z5280 Flying Club LLC · Castle Pines, COBuilt 2005 · S/N 172S9826N1074XKelley Air LLC · Milford, MIBuilt 2005 · S/N 20608233N10782Kearbey Brandon · Hillsboro, ORBuilt 2007 · S/N T20608773N10797Federal Flight LLC · Fairfax, VABuilt 2005 · S/N T20608525N107AFKummer Michael · Floyd'S Knobs, INBuilt 2001 · S/N 17281056N107ALAero Tech Services Inc · Lititz, PABuilt 2023 · S/N 172S12989N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202N107ELAa-Aero LLC · Lewes, DEBuilt 2024 · S/N 172S13140N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220N1082JWild Bills Aviation Inc · Tustin, CAS/N T20608775N1087CPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10268N10897Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10606N1089DHeavy Metal Air LLC · Farmingdale, NYBuilt 2006 · S/N 172S10269N108CTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608212N108ED95 Msg/Svra Aero Club · Edwards Afb, CABuilt 2007 · S/N 172S10631N108HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9049N108PFKeith Wilcox & Sons Inc · Rexburg, IDBuilt 1998 · S/N 18280092N108PTHenrie Aviation LLC · Fairfield, NJBuilt 2005 · S/N 172S10089N108TCAmeriflyers Of Texas Inc · Addison, TXBuilt 2001 · S/N 172S8801N1090JRocky Mountain Flight Consultants LLC · Boulder, COFirst renewal noticeBuilt 2006 · S/N 172S10271N1090VAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10283N1090WMedary Aviation LLC · Brookings, SDBuilt 2006 · S/N 172S10284N1092AGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10286N1097NSale Reported · Peoria, AZSale reportedBuilt 2005 · S/N 172S9821N1097YAtlas Aviation Tampa Inc · Tampa, FLBuilt 2006 · S/N 172S10296N109CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609748N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985N10AVMaak Holdings LLC · Missoula, MTBuilt 1999 · S/N 18280129N10CXAlameda County Sheriffs Office · Livermore, CAS/N 20608082N10YRAj Aviation LLC · Colby, KSBuilt 1999 · S/N T2068011N11019Cc Ventures LLC · Bowling Green, KYBuilt 2006 · S/N 172S10300N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913N1104XFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10297N1107GLunken Flight Training Center LLC · Cincinnati, OHBuilt 2006 · S/N 172S10303N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326N110SQLand Air & Sea LLC · Concord, NCBuilt 2006 · S/N 172S10384N1120ZWhite Wing Air LLC · Garden Grove, CAS/N 172S10313
Back to AD 2000-04-01