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

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.

N116JDRegistered aircraftBuilt 2009 · S/N 82662 N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167 N116JMMorgan James E · Everett, WABuilt 2009 · S/N RV20260 N116JTParks Kevin J · Arlington, TNBuilt 2009 · S/N 80982 N116JWAcvtg Aviation LLC · Wilmington, DEBuilt 1980 · S/N 335-0030 N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820 N116KWE2e4 Labs LLC · Wilmington, DEBuilt 2003 · S/N 0732 N116LLeavitt Mike · Kamas, UTBuilt 1964 · S/N TC-780 N116LHC&L Holzwarth Inc · Virden, ILBuilt 1974 · S/N 18801815 N116LTMarrow Henry G · Southern Pines, NCBuilt 2013 · S/N 6090 N116MRDibuono Michael · Clearwater, FLBuilt 2025 · S/N 0700 N116NJUsda Forest Service Fepp · Trenton, NJBuilt 1964 · S/N 18-8104 N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021 N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001 N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547 N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360 N116RJRegistered aircraftS/N 3227 N116RVJordan Jimmy W · Winnfield, LABuilt 1999 · S/N 60136 N116SB114b Holding Inc Trustee · Wilmington, DEBuilt 2000 · S/N 14678 N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73 N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242 N116SUBoolean Flight Sciences LLC · Mercer Island, WAS/N 18266668 N116TBMcmullan Francis G · Weirsdale, FLS/N 362 N116TSIrish Cindy L · Buckeye, AZBuilt 2003 · S/N 60399 N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529 N116UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1223 N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346 N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547 N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170 N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042 N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72 N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72 N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72 N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170 N1170LSweet Aviation LLC · Dover, DES/N 332 N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670 N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777 N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963 N1171JNational Test Pilot School · Mojave, CABuilt 2007 · S/N 18281985 N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363 N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72 N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361 N1172DPlaster James F · Winston Salem, NCBuilt 1953 · S/N 23220C N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672 N1172PSteed William B · Winnsboro, SCS/N 23-175 N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362 N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679 N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135 N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673 N1173QMoon Mitchell L · Covington, GAS/N 21059673

Back to AD 2007-04-19 R1