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.

N223HKHeinen Bros Agra Service Inc · Seneca, KSBuilt 2026 · S/N 14984 N223HWChesnut Tara M · Wasilla, AKBuilt 1960 · S/N 12 N223JHKp Aircraft LLC · Waco, TXBuilt 1999 · S/N 001 N223JPJohnson Vernon S · Salem, ORBuilt 1998 · S/N JP-4 N223KMccroskey Wesley D · Kingston, TNS/N 692 N223KCNovember Alpha LLC · Dover, DEBuilt 2003 · S/N 3435 N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447 N223KWMedic Choppers LLC · Springdale, ARS/N EA-382 N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493 N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223 N223MVallington Alexander M · Enterprise, ALBuilt 1960 · S/N D-6524 N223MEChem-Air LLC · Shreveport, LABuilt 2000 · S/N 18280746 N223MGBuffalo Sales & Leasing LLC · Missoula, MTBuilt 2000 · S/N 3125 N223MKKaul Mahendra · Bainbridge Island, WABuilt 2004 · S/N 1003 N223NKWandering Vet LLC · Mccook, NEBuilt 1955 · S/N 26814 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N223PKTexas Specialty Hunts Inc · San Angelo, TXBuilt 2022 · S/N 14575 N223PSTonkin Randy C · Vashon, WABuilt 1991 · S/N 20223 N223PTPlowman Holdings LLC · Willmar, MNBuilt 2010 · S/N 013 N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850 N223RLBeasley Andrew R · Colorado Springs, COBuilt 2007 · S/N 11375 N223RSJsh Farms Inc · Hermiston, ORBuilt 1987 · S/N 748 N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339 N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999 N223TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1998 · S/N 0079 N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719 N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757 N223UKWilliams Pat P · Salem, ORBuilt 1992 · S/N 2212 N223VAVeracity Aviation LLC · Seguin, TXBuilt 2025 · S/N 4925 N223WDGilliam Preston T · Philadelphia, PABuilt 1964 · S/N 28-20366 N223WHPerrin James F · Bancroft, WIBuilt 1964 · S/N 18051355 N223WMMoore Warren C · Magnolia, TXBuilt 2005 · S/N 4193 N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251 N223YZMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881536 N223ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881608 N2240BK & D Dakota LLC · Avon, OHBuilt 1978 · S/N 28-7911015 N2240EKellogg Jeffrey D · Adams Center, NYBuilt 1978 · S/N 17271200 N2240GThunderbird Aircraft Company · Bloomington, MNBuilt 1978 · S/N 28-7916217 N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233 N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849 N2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1971 · S/N 28-7125625 N2241Davis Clint H · Paola, KSFirst renewal noticeS/N TD-221 N22419Gehres Shawn E · Enterprise, ALBuilt 1978 · S/N 32R-7885270 N2241FHaag Douglas A · Collierville, TNBuilt 1967 · S/N 310L-0041 N2241GOwens Wilbur · Rch Palos Vrd, CABuilt 1978 · S/N 28-7990229 N2241KFlickinger Charles · Hermitage, PABuilt 1978 · S/N 28-7916236 N2241NBell Michael C · Sammamish, WABuilt 1979 · S/N 28R-7918043 N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186 N2241TWhittock Tyson H · Anchorage, AKS/N 185-1397 N2241ULatimer Mark A · Roanoke, TXBuilt 1968 · S/N 482

Back to AD 2007-04-19 R1