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.

N1137Y412 Jackson Site Development LLC · Oxford, MSBuilt 2005 · S/N 18281602 N1138EGemfire Ventures LLC · Saint Petersburg, FLBuilt 1977 · S/N 985-77 N1138LTop Aircraft Leasing LLC · Wilmington, DEBuilt 1964 · S/N 300 N1138PYs Pharmtech · San Diego, CABuilt 1981 · S/N 24-1147 N1138XPierce Nathaniel Antonio · Magnolia, DEBuilt 1975 · S/N 28R-7535256 N1139MMarshall J B · Talbott, TNBuilt 1975 · S/N 18264230 N1139UFettig Peter J · Bismarck, NDBuilt 1976 · S/N 17266868 N113ABSafford Aviation Service Inc · Coolidge, AZBuilt 1973 · S/N TC-1622 N113ACInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 2121 N113AFRa Aviation LLC · Clinton, LABuilt 2008 · S/N 12133 N113AGOrban Cedric · Coral Springs, FLBuilt 1977 · S/N U20603750 N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182 N113AWMontana 1 LLC · Missoula, MTBuilt 1983 · S/N EA-346 N113BAPreston Richard R Trustee · Albuquerque, NMBuilt 1975 · S/N 17266046 N113BCBass William E · Anchorage, AKBuilt 1996 · S/N 001 N113BHBighorn Airways Inc · Sheridan, WYBuilt 1967 · S/N 18051844 N113BMAcme Finance LLC · Flagstaff, AZBuilt 2003 · S/N 60467 N113BSHill Jason A · Cody, WYBuilt 1964 · S/N 18255205 N113CCBowman Stephen L · Palm Bay, FLS/N 5264 N113CDDowning Charles E · West Melbourne, FLFirst renewal noticeBuilt 1998 · S/N 001 N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076 N113CKMorgan Joel E · Mcalester, OKBuilt 2003 · S/N 22378 N113CMHuling Clinton D · Dutch Harbor, AKBuilt 1960 · S/N 18253043 N113CTCentral Texas College · Killeen, TXBuilt 2024 · S/N 1036 N113DDLane Michael D · Fruitvale, TXBuilt 2000 · S/N 379 N113DLDiamond Aaron M · Ramsey, NJBuilt 1979 · S/N 1 N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961 N113DUWick Berchmans D · Anchorage, AKBuilt 2013 · S/N 82599 N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075 N113FMaddox Jody S · Bouse, AZBuilt 1960 · S/N 52725 N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229 N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996 N113GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881455 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N113GSSchulte Flyers LLC · Union, KYBuilt 2004 · S/N 0934 N113HBSnyder Shad J · Quincy, WABuilt 1983 · S/N 18268318 N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159 N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226 N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027 N113JGTaveniku Mikael · Painted Post, NYS/N DM0113 N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000 N113JKBusciglio Daren A · Tampa, FLBuilt 2009 · S/N 21369 N113JLHare Richard C · Northville, MIBuilt 1966 · S/N D-8167 N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615 N113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 3134 N113JTAerotransplant Inc · Marfa, TXBuilt 1980 · S/N E-1729 N113JWGrass Roots Aviation LLC · Bend, ORBuilt 2004 · S/N RV623839 N113JYFreeman Alan M · San Antonio, TXS/N 482R N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107 N113KCGolden Valley LLC · Missoula, MTBuilt 2018 · S/N 41573

Back to AD 2007-04-19 R1