OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N2429RJones Adam · Fairbanks, AKBuilt 2000 · S/N T20608161N2429SAdams Kelly M · Galveston, TXBuilt 1979 · S/N 18-7909148N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390N2429XMontpetit Steven W · New Richmond, WIBuilt 1965 · S/N 18256329N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732N242ABBrankov Branimir · Naples, FLS/N 0678N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183N242AKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 172S11091N242AMZike Jay N · Lindsay, CABuilt 2003 · S/N 2242N242AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13204N242AVN242av LLC · Manassas, VABuilt 1972 · S/N 17260470N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010N242BDDouglass Bryan C · Missoula, MTBuilt 2011 · S/N 40084N242BTFriends Of Army Aviation Ozark · Ozark, ALBuilt 1965 · S/N TF-24N242BWLasensky David W · Newtown Square, PAS/N 10214N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459N242CCRecreational Management Inc · Mount Ida, ARBuilt 1997 · S/N 3246095N242CDManly Anderson J · White Salmon, WABuilt 1985 · S/N 1N242CMZlin Parts America LLC · Elmwood, WIBuilt 1994 · S/N 0661N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715N242DCRedtail Aviation Services LLC · Inglewood, CABuilt 1994 · S/N 0668N242DFForce Dave Jr · Glenwood Springs, COBuilt 2005 · S/N 1N242DGWing Over Aerobatics LLC · Weirsdale, FLBuilt 1995 · S/N 0687N242DKInter Island Yachts Inc · Rncho Pls Vrd, CABuilt 1995 · S/N 0689N242DSSneed Jason C · Spanish Fork, UTBuilt 1997 · S/N 001N242DTSherlock William H · Greenbrae, CABuilt 1997 · S/N LRC-1N242ENorman Brian D · Roseau, MNBuilt 1973 · S/N 17261819N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229N242EMDay Grain Co Inc · Braman, OKBuilt 1974 · S/N 18263224N242EPEpic Aviation Inc · New Smyma Beach, FLBuilt 2024 · S/N 172S13243N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514N242HARounds Agronomy LLC · Pierre, SDBuilt 1961 · S/N D-6626N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N242HRShine Dylan · Jupiter, FLBuilt 1998 · S/N 159N242JBMcgregor Todd R · Cincinnati, OHBuilt 1966 · S/N CE-44N242JMLitsky Steven H · University Place, WABuilt 1994 · S/N 0677N242JWAviation Leasing Co LLC · Ooltewah, TNBuilt 2019 · S/N 172S12279N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111N242LManda Aviation LLC · Bakersfield, CABuilt 2016 · S/N L2K-219N242LESky King Aviation Services Inc · Ardmore, OKBuilt 1990 · S/N 1N242LHMatthews Micheal S · Reno, NVBuilt 1994 · S/N 0673N242LPDavenport Rebecca · Fresno, CABuilt 2000 · S/N 24340N242MFerrell Alan · Arlington, OHBuilt 1963 · S/N D-7112N242MBRed Bird Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 0911N242MCMcg Aviation LLC · Miami, FLS/N 18260815
Back to AD 2007-04-19 R1