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.

N122KRRutkowski Kurt A · Cresson, TXBuilt 1999 · S/N 2360 N122KYSeminole Flying & Soaring Inc · Clermont, FLBuilt 1968 · S/N 25-4576 N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413 N122MG122mg Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1250 N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043 N122MLLutz Michael A · Findlay, OHBuilt 2000 · S/N 645 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122PGMcgaw Thomas D · Petaluma, CABuilt 1961 · S/N TC-149 N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265 N122PMFrench Benjamen M · Dillon, MTBuilt 2025 · S/N 001 N122PPStout Andy · Livingston, TXBuilt 1990 · S/N 526 N122PTLove Ralph E Jr Trustee · Carmel, CABuilt 2008 · S/N L2K-184 N122RLuv2av8 · Fort Pierce, FLBuilt 1997 · S/N L IV-169-P N122RCCurtis Alvis Jr · Bakersfield, CAS/N 21059298 N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397 N122RHPadussis Gary Theodore · Cape May, NJBuilt 1993 · S/N 93-301017 N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177 N122RRDebold David A · Spring, TXBuilt 1961 · S/N D-6706 N122RWShick Kenneth W · Rosamond, CABuilt 2004 · S/N GT001 N122SGTanz LLC · Helena, MTBuilt 2004 · S/N 80094 N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118 N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N122TFWampler Kenneth E · Pottstown, PABuilt 1957 · S/N 21022 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N122TVButler Aaron · Rupert, IDBuilt 1976 · S/N 1049 N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794 N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203 N122VKWings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S9856 N122VUWeishaar Richard N III · Roselle, ILBuilt 1991 · S/N 10058 N122VWJk Aviation LLC · Fresno, CAS/N D-6435 N122WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12396 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094 N122XXGloss Mountain Aviation Foundation · Meno, OKBuilt 1990 · S/N 9001 N122YBRobinson Helicopter Co · Torrance, CABuilt 2002 · S/N 3309 N1230EMcmahan Johnny W · Gakona, AKBuilt 2020 · S/N 001 N1230GFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9838 N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002 N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005 N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268 N1230UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020277 N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104 N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875 N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793 N1231JMattson Paul · Chula Vista, CAS/N 231 N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251 N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099 N1231ZD&J Vtail LLC · Punta Gorda, FLBuilt 1961 · S/N D-6693

Back to AD 2007-04-19 R1