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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327 N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329 N20487Point To Point Air LLC · Arlington, WAS/N 17261330 N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331 N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904 N2048BCicciari David A · Cincinnati, OHBuilt 1978 · S/N E-1402 N2048GIozia Luz E · Ruidoso, NMS/N 51348 N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857 N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244 N2048V5l Aviation LLC · Decatur, TXBuilt 1978 · S/N E-1404 N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987 N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828 N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333 N20491Ross Johnathan M · Eagle River, AKBuilt 2002 · S/N 002 N20494Aviation Group Jmj Inc · Callahan, FLS/N 17261337 N20495Pitts Dan O · Soldotna, AKBuilt 1988 · S/N 1045 N20496Hess Garrett J · Fullerton, CABuilt 1973 · S/N 17261339 N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405 N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234 N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190 N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445 N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985 N2049XTaylor Stephen A · Benton, KSBuilt 1965 · S/N 18256149 N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398 N204BPBarbers Point Flight School LLC · Kapolei, HIFirst renewal noticeBuilt 2019 · S/N 104/US N204CMMorgan Kenneth J · Norridgewock, MEFirst renewal noticeBuilt 1975 · S/N 17265224 N204DKElgin John M · Cody, WYBuilt 2002 · S/N 60285 N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119 N204GACoen Brady · Wiley, COBuilt 1997 · S/N 200-9724F N204GLChrist Robert D · Mandeville, LABuilt 2014 · S/N 1204 N204GSBooth William F Sr · Fredericksburg, VABuilt 2008 · S/N 40274 N204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0373 N204HWNordman Marvin J · Great Bend, KSBuilt 2004 · S/N 25151 N204JWN204jw LLC · Fort Worth, TXBuilt 1976 · S/N 18265167 N204KKLofstrom Ashley N · Wasilla, AKBuilt 1989 · S/N 1232 N204LCUtah State University · Logan, UTBuilt 2004 · S/N 10248 N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262 N204MATsiu LLC · Wilmington, DEBuilt 2000 · S/N 2075 N204MCB-Line Air LLC · Malcom, IABuilt 2008 · S/N 12596 N204MEArgo Aviation Inc Trustee · Wilmington, DEBuilt 1989 · S/N 909 N204MMAvest Ltd · Hilltop Lakes, TXS/N 24-0718 N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601 N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844 N204RJFlying Hoosier Js LLC · Carmel, INBuilt 2004 · S/N 1375-2004 N204RKHermann Ron A · Sarasota, FLBuilt 1985 · S/N 28-8611003 N204RVCollette John D · Las Vegas, NVBuilt 1999 · S/N 832 N204SDOstern Mark Lynn · Rapid City, SDS/N 958-2004 N204SGSquillace Daniel J · Cary, NCBuilt 2005 · S/N 40.482 N204SLBethesda Family Lp · Auburn, CAS/N 0023 N204SMKrug Lee A · Coatesville, PABuilt 2005 · S/N 70759

Back to AD 2007-04-19 R1