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.

N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023N241GWWheeler Gregory R · Spicewood, TXS/N 2248N241HAMcfarland Mark C · Cottage Grove, ORBuilt 1960 · S/N CD-84N241HBEngelmann Christopher · Mayer, MNBuilt 2019 · S/N 1241N241HCButcher Robert E · Friendswood, TXBuilt 2005 · S/N 81966N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011N241JESmedshammer Paul J · Petaluma, CABuilt 2001 · S/N 23868N241JJN241jj LLC · Louisville, KYBuilt 2025 · S/N 18283313N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241KDReiter Kenneth L · Plano, TXBuilt 1998 · S/N 162N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602N241LMEntropy Elevation LLC · San Jose, CABuilt 2015 · S/N 1124N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088N241MAKim Sung Su Trustee · Upland, CABuilt 2010 · S/N 3110N241MBFlying Brick LLC · Monroe, NCBuilt 2004 · S/N 0910N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761N241MJMj Aero LLC · Mims, FLBuilt 1987 · S/N 1055N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051N241NPNauti Plane LLC · Wilton Manors, FLBuilt 1968 · S/N TE-648N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214N241PAHilow LLC · Woodbury, MNBuilt 2009 · S/N 3069N241PCPlucinski David J · San Clemente, CABuilt 2005 · S/N 1385-2005N241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 0102N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422N241RSalamon Uri · Boerne, TXBuilt 1980 · S/N CE-925N241RAGreat Escape Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 1322-2001N241RBJankowski Richard S · Shenandoah, TXBuilt 1997 · S/N 23274N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916N241RSHood Jeffery M · Ada, OKBuilt 2008 · S/N E-3879N241SGFalasco Joseph R · Little Rock, ARBuilt 1999 · S/N 29-0196N241SHSky West Aviation Inc Trustee · Albuquerque, NMS/N 0398N241SLHickman Ira · West Richland, WABuilt 2005 · S/N 1283N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113N241TWScotton Bradley D · Galena, AKBuilt 1996 · S/N TW96-002N241UTecnam US Inc · Sebring, FLBuilt 2023 · S/N 241/USN241VSDjd Aero Corp · Wilmington, DEBuilt 2000 · S/N 0729N241VUDynamic Aircraft Services LLC · Hurst, TXS/N 28-7515409N241VYShallbetter Joseph R · Marana, AZBuilt 1999 · S/N 1449N241WB1rk Ltd · Winston Salem, NCS/N TH-2246N241WHMiller Michael A · Huffman, TXBuilt 1951 · S/N 18-816N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922N241WTCowtown Aircraft LLC · Spring Branch, TXBuilt 2009 · S/N 22453
Back to AD 2007-04-19 R1