OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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

N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554N1919PBarnett David K · Brock, TXS/N 22-2666N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214N191AAPelz Thomas G · Boscobel, WIBuilt 1959 · S/N D-5914N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471N191ACLoewen Jason Scott · Wenatchee, WABuilt 1993 · S/N 711-93N191ARJack Dixon Inc · Haiku, HIBuilt 1977 · S/N 17270069N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577N191BJClausen Kenneth W · Rosalia, WABuilt 1992 · S/N 21233N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399N191CGAugust Aero LLC · Kalispell, MTBuilt 1978 · S/N 191N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057N191DHLee Kevin B · Beulah, NDBuilt 1999 · S/N 2035N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206N191DKAdriatic Holdings LLC · Cheyenne, WYS/N S/H 191N191DMOlson Tim O · Saint Onge, SDBuilt 1999 · S/N 426-99N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716N191GSeratt Timothy G · Harviell, MOBuilt 2015 · S/N TD 1N191GA5056 Bonanza LLC · Tulsa, OKBuilt 1957 · S/N D-5056N191GCHughes Aviation LLC · Bedford, NHBuilt 1991 · S/N 10020N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992N191JStyer David B · Pendleton, ORBuilt 1977 · S/N 390N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042N191JSStaben Jon C · Freeport, ILBuilt 2006 · S/N 0305N191JWWatkins James P · Bakersfield, CABuilt 2015 · S/N 0269N191KBudd William M · St Simons Island, GABuilt 1946 · S/N 252N191KMDodson International Parts Inc · Rantoul, KSS/N 0017N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N191MPate Earl G · Hickory, NCBuilt 1992 · S/N 20109N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248N191PCBad Attitude LLC · Lisbon, OHBuilt 2002 · S/N 896-2002N191PFDunston Douglas E · Saint Paul, MNBuilt 2010 · S/N 90474N191RLOpen Air Properties LLC · Jonesboro, ARS/N 14575N191SBRasch Hellmut G · Tomball, TXBuilt 1999 · S/N 24417N191SDCrockard Scott M · Oregon City, ORBuilt 2018 · S/N 90927N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232N191SSRoberts Anthony Curtis · Dallas, TXBuilt 1998 · S/N 3165N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840N191XRosendahl Paul O · Sangar, TXS/N 129
Back to AD 2007-04-19 R1