OpenAirDocs.org
AD 2001-09-06

Registered aircraft · 1,216

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:2001-09-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-09-06')
  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.

N100CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T20609818N100KAConservation Flight LLC · Bronx, NYBuilt 2006 · S/N T20608602N1029TThomson Heath · Portola Valley, CABuilt 1999 · S/N T20608067N102AKRegistered aircraftBuilt 2006 · S/N 20608264N102RSSuttle Richard T Jr · Austin, TXBuilt 2018 · S/N T20609551N103MRDeepvine Partners LLC · Simonton, TXBuilt 2004 · S/N T20608455N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101N10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194N104PSDepartment Of The Interior · Boise, IDBuilt 2019 · S/N T20609566N105NRState Of Minnesota · Grand Rapids, MNBuilt 2024 · S/N T20609780N1068YTextron Aviation Inc · Wichita, KSS/N T20609869N1074XKelley Air LLC · Milford, MIBuilt 2005 · S/N 20608233N10782Kearbey Brandon · Hillsboro, ORBuilt 2007 · S/N T20608773N10797Federal Flight LLC · Fairfax, VABuilt 2005 · S/N T20608525N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202N1082JWild Bills Aviation Inc · Tustin, CAS/N T20608775N108CTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608212N109CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609748N10CXAlameda County Sheriffs Office · Livermore, CAS/N 20608082N10YRAj Aviation LLC · Colby, KSBuilt 1999 · S/N T2068011N1123FUrsus Air Services · Anchorage, AKBuilt 2002 · S/N 20608173N1128WChance Aviation LLC · Sugar Land, TXBuilt 2017 · S/N T20609512N11345Enviroplus Consulting Inc · Rosamond, CABuilt 2006 · S/N T20608668N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077N113CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609735N113KHTextron Aviation Inc · Wichita, KSS/N T20609859N1155MLagasse Michael · Newburyport, MABuilt 2006 · S/N T20608683N1155PN1155p Corp Trustee · Wilmington, DEBuilt 2003 · S/N 20608193N1165YUgly Johns Aircraft LLC · Afton, OKBuilt 2006 · S/N T20608686N116MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2002 · S/N T20608357N118EGSpring Hill Aviation LLC · Cincinnati, OHBuilt 2018 · S/N T20609542N1197LBoothe Vincent A · Fairhope, ALBuilt 2006 · S/N T20608697N119FEnhancement Group LLC · Ocean Springs, MSBuilt 2025 · S/N T20609826N11LJHandyquick Mn LLC · Woodbury, MNBuilt 2004 · S/N T20608485N1206Parks Bob C · Big Spring, TXBuilt 2018 · S/N T20609534N1215GValley Wide Engineering And Construction Inc · Trona, CABuilt 2017 · S/N T20609515N1221Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2018 · S/N T20609538N1229KTextron Aviation Inc · Wichita, KSS/N T20609871N122MENorton Mark Trustee · Stateline, NVBuilt 2000 · S/N T20608153N124LLLyonfish Aviation Holdings LLC · Wellington, FLBuilt 2022 · S/N T20609703N12522Island Root Aviation LLC · West Palm Beach, FLBuilt 2006 · S/N T20608671N1258FRsns LLC · Snowflake, AZS/N T20608674N125ALNby Productions · Bristow, VABuilt 2021 · S/N T20609639N125LFHubbard Capital LLC · Nashville, TNBuilt 2023 · S/N T20609729N125MDMaryland Aviation Administration · Bwi Airport, MDBuilt 2000 · S/N 20608099N12730Silver Creek Aviation Services · Fort Worth, TXBuilt 2007 · S/N 20608302N1276AAir Land Ventures 3 LLC · Berwyn, PABuilt 2007 · S/N T20608794N127JEGillian Michael · Batavia, ILBuilt 2006 · S/N T20608678N1296MThacker Thomas L Trustee · Hurricane, UTBuilt 2008 · S/N T20608803N130CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609133
Back to AD 2001-09-06