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.

N221MFWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267380 N221MHHarmel Michael B · Melba, IDBuilt 2004 · S/N 60595 N221MLWamu Fly N Fish LLC · Portland, ORBuilt 1972 · S/N 18261525 N221MRGaluk Douglas P · Wisconsin Rapids, WIS/N E-1576 N221NPohl Ronald O · Englewood, COBuilt 1981 · S/N E-1892 N221NDBamford Benjamin R Trustee · Middlebury, VTBuilt 2001 · S/N 2842110 N221NYFarukh Shroff · Pittston, PABuilt 1981 · S/N 17274978 N221PAquino Richard J · Westfield, INBuilt 1999 · S/N 60049 N221PJHinton Cody J Trustee · Indian Land, SCBuilt 1977 · S/N AA5A0473 N221PMHester Thomas F · Boulder, UTBuilt 2004 · S/N 451-2003 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221RBSchmidt Aaron · Bisbee, AZBuilt 1992 · S/N 1157 N221RFFunk Robert D · Tyler, TXBuilt 1964 · S/N D-7307 N221RJSchneider Ronald J · Tucson, AZS/N 1 N221RLLorenz Richard A · Ham Lake, MNBuilt 2023 · S/N 223 N221RPPastor Randall J · Granite Bay, CABuilt 2004 · S/N 0878 N221SDKimball James R · Indian Trail, NCBuilt 1974 · S/N 28R-7535081 N221SMMccain Stephen M · Columbia, MSBuilt 1976 · S/N 17267274 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N221TJSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N 17271059 N221TLLogan Thomas D · Incline Village, NVBuilt 1964 · S/N D-7652 N221TMTaildragons LLC · Albuquerque, NMBuilt 1997 · S/N 3974 N221TUMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881531 N221VArea 52 Holdings Inc · Darlington, SCBuilt 2003 · S/N 29-0295 N221WA98x LLC · Caddo Mills, TXBuilt 1970 · S/N 28-26840 N221WMUtah Helicopter LLC · Spanish Fork, UTBuilt 2008 · S/N 4285 N221WSChaz LLC · Wilmington, DEBuilt 1976 · S/N CE-642 N221WYCreeque Alley Ventures LLC · Missoula, MTBuilt 2014 · S/N 3221 N221XNapflin Erich P · Wasilla, AKBuilt 1977 · S/N 7139C N221YDMcafee Michael D · Chandler, AZBuilt 1965 · S/N 580 N221ZScremin Claudio F · Eliot, MEBuilt 2009 · S/N 80304 N221ZTSg Aviation Inc · Clearwater Beach, FLBuilt 2002 · S/N 3311 N222Foutz Robert V · Dublin, VABuilt 2008 · S/N 90988 N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717 N22204Anania Nickolas · West Ossipee, NHBuilt 1978 · S/N 28-7990071 N22205Venaleck Joan · Concord Township, OHBuilt 1974 · S/N 17264058 N2220ANelson David R Trustee · New Richmond, WIBuilt 1952 · S/N 22-638 N2220KLach Richard · Weldon, CABuilt 1957 · S/N 22-5761 N2220LLegitimate Business LLC · Las Vegas, NVS/N MC-445 N2220NDushek Matthew S · West Hartford, CTBuilt 2000 · S/N 29-0228 N2220PBryant Stephen C · Anchorage, AKBuilt 1955 · S/N 22-3302 N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165 N2220YFarid Zia Physical Therapist A Professional Corp · El Centro, CABuilt 2005 · S/N 18281676 N2221Conley James Andrew · Merced, CABuilt 1960 · S/N 52538 N2221CCts Aviation Inc · Galesburg, MIBuilt 1953 · S/N 30521 N2221KInner Circle Air Group LLC · Dallas, TXBuilt 1978 · S/N 28-7916227 N2221PHardin John M · Terrell, TXS/N 23-830 N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681 N2221TBannow Robert J · Marinette, WIBuilt 1971 · S/N 28-7105188 N2221YThomas Raymond N · Springfield, SDBuilt 1967 · S/N 17700021

Back to AD 2007-04-19 R1