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.

N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496 N192AGBp Aviation LLC · Gilbert, AZBuilt 2005 · S/N 29-0406 N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507 N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016 N192BAHarkrader Aviation LLC · Louisa, VABuilt 1974 · S/N 459-74 N192CAVines Allen E Jr · Hoover, ALBuilt 2007 · S/N 1048-2007 N192CCU S Department Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0056 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N192CRIvas Edward P · Great Barrington, MABuilt 1992 · S/N 92-301016 N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021 N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020 N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374 N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92 N192JKWest Gregory B · Cummings, GABuilt 2004 · S/N 29-0353 N192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2005 · S/N 172S9894 N192JRCessna 185 LLC · Birmingham, MIS/N 18502286 N192LAMagnum Securities LLC · Sarasota, FLBuilt 2015 · S/N 40.1192 N192MCWarrington Flying Club Inc · Doylestown, PABuilt 2006 · S/N 172S10162 N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454 N192MHHolland James Michael · Fort Collins, COBuilt 2005 · S/N 90556 N192QFisher Robert · Shoreacres, TXS/N TC-783 N192RDisarro Wayne · Ketchikan, AKBuilt 2003 · S/N RK 100 1 N192RGCinda Corporation · Lehighton, PABuilt 1992 · S/N 14561 N192RKWeber Martin Trustee · Marthasville, MOBuilt 1992 · S/N 1854 N192TGSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 18281524 N192VDefenbaugh Matthew J · Biggsville, ILBuilt 1999 · S/N 22107 N192YSanders Leonard S III · Electric City, WABuilt 2000 · S/N 18280912 N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828 N1930TWing John · Fort Worth, TXS/N 28-7125442 N1930UGazzano Leonard S Trustee · Yerington, NVBuilt 1999 · S/N 1930 N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030 N1931HMountain Air Aviation LLC · Fruit Heights, UTBuilt 2006 · S/N 172S10128 N1931JAerodyme Corp · South Burlington, VTBuilt 1976 · S/N 14031 N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504 N1931TFordham Scott · Sag Harbor, NYBuilt 1975 · S/N AA50744 N1931VRegistered aircraftBuilt 1974 · S/N 17263799 N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589 N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031 N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417 N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623 N1932VFarmland Aviation LLC · Glenwood, IABuilt 2005 · S/N 84232 N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239 N1932ZSpencer David E · Woodville, ALBuilt 2015 · S/N 001 N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023 N1933HBlock Andrea · Chandler, AZS/N 28-7725170 N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417 N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487 N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151 N1933WHanson Garrick D · Clayton, NCS/N MB-597

Back to AD 2007-04-19 R1