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.

N142CFArq Aviation LLC · Wilmington, NCBuilt 2020 · S/N 172S12437N142CJSheppard Travis R · Redmond, ORBuilt 2007 · S/N 91286N142CTMiddleton Charles H · Hamilton, INFirst renewal noticeBuilt 1976 · S/N 310R0629N142DGYuba Sutter Aviation · Olivehurst, CABuilt 1981 · S/N BB-01N142DLRoss Branta Enterprises · Boise, IDBuilt 2004 · S/N 18281470N142DMRegistered aircraftBuilt 1997 · S/N 584N142DWNelson Jim · Midlothian, TXBuilt 1998 · S/N 2449N142EN142e LLC · Page, AZBuilt 1967 · S/N 30-1479N142EJAskwig Michael C · Lincoln, MIS/N 372N142FGall Peter · Morgantown, WVBuilt 1966 · S/N TE-221N142FAKrause Frank · Sarasota, FLBuilt 2010 · S/N 144N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177N142GVan Strien Greg · Lowell, MIBuilt 2019 · S/N 22278N142GXDicey Emery B · Port Orange, FLBuilt 2004 · S/N 29-0342N142HAHonaker Group LLC · Sellersburg, INBuilt 1975 · S/N 17266306N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020N142JGRegistered aircraftBuilt 1999 · S/N 3921N142JHParoaria LLC · Williamsville, NYBuilt 2008 · S/N 40454N142JPEvans Jesse G · Powder Springs, GABuilt 2000 · S/N 23636N142KSSoares Ken J · Pasco, WABuilt 2007 · S/N 90514N142KWPhillips John C · Moneta, VABuilt 2019 · S/N 40610N142LESky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 01N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177N142LJObr Leasing · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282272N142LLHr II LLC · Prescott, AZBuilt 2001 · S/N 167N142LMLamm Aviation Lc · Lees Summit, MOBuilt 2015 · S/N 41420N142MPeterson Dana Timothy · Eldersburg, MDBuilt 1960 · S/N D-6585N142MCCassen Mark E · Wilson, WYBuilt 1973 · S/N TC-1579N142MGSanta Maria Software · Santa Maria, CABuilt 1999 · S/N 1N142MJFranklin Justin L · Mimbres, NMBuilt 1984 · S/N 352N142MLGuinn Gary L · Tulsa, OKBuilt 2004 · S/N 3RX034N142NDSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1989 · S/N 2841229N142PLZbigniew Chudy · Southington, CTBuilt 2018 · S/N 70277N142PSSidney Aviation LLC · Sidney, NEBuilt 1999 · S/N 6022N142RSReinmuth Michael W · Lopez Island, WAS/N 18253832N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635N142SMShandelee Energy LLC · Tulsa, OKFirst renewal noticeBuilt 1994 · S/N SMS01N142TSAmberly Holdings LLC · Fleming Island, FLS/N 486-74N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841N142UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11490N142VABuffalo Sales And Leasing LLC · Missoula, MTBuilt 2005 · S/N 3771N142VPMortland Thomas F · Duxbury, MABuilt 1959 · S/N 23-1593N142WHendry James W · Cortez, COS/N 2219N142WBDay Craig · Braman, OKBuilt 2011 · S/N 25558N14303Fejes William C · Seward, AKS/N 18-7409068N14304Sterrett Larry D · Havre, MTBuilt 1974 · S/N 18-7409065N14305Vinton Daniel H · Whitman, NEBuilt 1974 · S/N 18-7409069N14309Metz Daniel J · Brighton, COBuilt 1971 · S/N 18-7409073N1430GRoyal Wolf Aviation LLC · Lubbock, TXBuilt 1962 · S/N CD-453
Back to AD 2007-04-19 R1