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.

N18SAWatkins Aviation LLC · Kenton, OHBuilt 2005 · S/N 1401 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560 N18SJJones Paul Wesley · Dyer, INBuilt 1992 · S/N 266 N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795 N18SVWessel Marvin E Jr · Camp Verde, AZBuilt 1993 · S/N 580R N18SWShannon Kenneth J · Cleveland, TXBuilt 1973 · S/N 28-7425049 N18TATailwind Aviation LLC · Richmond, VABuilt 2021 · S/N 7034 N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N18TLCarey Nicolas J · Rosamond, CAS/N 18259225 N18TTRoemer Peter P · Manitowish Waters, WIBuilt 1971 · S/N 376 N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450 N18TWN-88xk Medical Aviation LLC · Kalispell, MTBuilt 2001 · S/N DB-1 N18UGSale Reported · Wasilla, AKSale reportedBuilt 1958 · S/N 186424 N18VBWright Troy A · Milton Freewater, ORBuilt 2022 · S/N 74392 N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VPGuillot Larry D · Harvest, ALBuilt 1969 · S/N 315 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N18VTRutz Jack Thomas · Colchester, VTBuilt 2002 · S/N 2001 N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928 N18WACarmel Christopher F · Bozeman, MTBuilt 2001 · S/N 2165 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N18WMIsland Cay Express Inc · Wilmington, DEBuilt 1980 · S/N 32-8006047 N18WNSarah Business LLC · Merritt Island, FLBuilt 2001 · S/N 001 N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125 N18WRN18wr LLC · Mesa, AZS/N 28-8190185 N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860 N18WXEastern Stearman Inc Trustee · Leesburg, VABuilt 1996 · S/N 1180 N18WYOverfield LLC · Greensburg, INBuilt 2008 · S/N 3038 N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353 N18XCCrosswind Air LLC · Canyon, TXBuilt 2005 · S/N 0001 N18XMUfer John M · Truman, MNBuilt 1973 · S/N 621-74 N18YKLeyva Gregory G · Wilbur, WABuilt 2009 · S/N TC0801040 N18YLTj Helicopters LLC · Seymour, TNBuilt 2006 · S/N 11171 N18YTBeavers Michael B · Bulverde, TXBuilt 2013 · S/N 81004 N18YYBartlett Kelly J · Soldotna, AKS/N 002 N18ZMays Paul R · Toney, ALBuilt 1971 · S/N 394 N18ZBBailey John Bryan · Eagle River, AKBuilt 1977 · S/N 18-7809054 N18ZFReel Chad A · Wasilla, AKBuilt 1951 · S/N 18-1159 N18ZPPierce Lestley R · Henderson, NVS/N 18263562 N18ZZGardom Brandon D · Spirit Lake, IDBuilt 1959 · S/N 18-3380 N19007Beal Peter D · Apex, NCBuilt 1994 · S/N 2079 N1900PHauff Delmar M · Julesburg, COBuilt 1955 · S/N 22-2647 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162 N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000 N1900YMarrero Francisco J · Lake Charles, LABuilt 1964 · S/N 2684 N1900ZChavey Gary G · Manchester, MIBuilt 1984 · S/N 8024C N1901AHatbright Farm LLC · Wilmington, DEBuilt 1977 · S/N VAC-81-77

Back to AD 2007-04-19 R1