Registered aircraft · 40,396

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N6618PChurchill John C · Parker, AZBuilt 1960 · S/N 24-1739 N6618VLang Gerald K · Baker, MTBuilt 1980 · S/N 172RG0783 N6618WLe Ariya · La Crosse, WIBuilt 1965 · S/N 28-20713 N6619DBannwart Justin S · North Liberty, INBuilt 1979 · S/N 17272906 N6619JBjelland Nathan D · Phoenix, AZBuilt 1968 · S/N 28-5085 N6619PRatliff Byron L · Paragould, ARBuilt 1960 · S/N 24-1740 N661FLS B Enterprise LLC · Marshall, TXBuilt 1971 · S/N 28-7125581 N661JCKruse Thomas S · Mena, ARBuilt 1999 · S/N 23001 N661JPEvans Craig A · Irvine, CABuilt 1980 · S/N 661 N661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 2890028 N661QS&S Aircraft Inc · Bennington, VTBuilt 1959 · S/N TD-214 N6620CDieck Steven L · Lake Villa, ILBuilt 1966 · S/N 3327 N6620DPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 17272907 N6620PMagel David J · Lakemoor, ILBuilt 1960 · S/N 24-1741 N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217 N66213Global Adventures N66213 LLC · Hollywood, FLBuilt 1983 · S/N 17275980 N66215Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275982 N6621DCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17272908 N6621JMardis David P · Warner Robins, GABuilt 1968 · S/N 28-5087 N6621PR C Antique Aviation LLC · Saint Louis, MOBuilt 1960 · S/N 24-1742 N6621RRasmussen Paul A · Lakewood, CABuilt 1974 · S/N M-1606 N6621WGbg Aviation LLC · Foristell, MOBuilt 1965 · S/N 28-20717 N6622DArq Aviation LLC · Wilmington, NCBuilt 1979 · S/N 17272909 N6622JBernstein Matthew D · North Charleston, SCBuilt 1968 · S/N 28-5089 N6622UArmistead Jack R · Birmingham, ALBuilt 1963 · S/N 117 N6622WBayko John T · Marengo, OHBuilt 1965 · S/N 28-20718 N66230East Hill Flying Club Inc · Ithaca, NYBuilt 1983 · S/N 17275985 N6623JAcadian Aviation Pilot Training Centre Inc · Lafayette, LAS/N 28-5090 N6623PHopkins Daryl L · Gentry, ARBuilt 1959 · S/N 24-1744 N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240 N6624ARegistered aircraftBuilt 1981 · S/N 18-8109029 N6624GBob Hoover Academy · Salinas, CABuilt 1979 · S/N 17273611 N6624HSakata Lissa C · Falls Church, VAS/N 17265515 N6624JN6624 LLC · Reserve, LABuilt 1968 · S/N 28-5091 N6624PMiller David J · Washington, IAFirst renewal noticeBuilt 1960 · S/N 24-1746 N66251T Air LLC · Bonita Springs, FLBuilt 1979 · S/N M-2178 N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203 N6625JJustice Andrew C · Amory, MSBuilt 1968 · S/N 28-5092 N6625WR W Bright Architects Inc · Tulsa, OKBuilt 1965 · S/N 28-20722 N6626DDrozs Allen P · Decatur, ILBuilt 1979 · S/N M-2179 N6626JSn Aviation LLC · Richardson, TXBuilt 1968 · S/N 28-4919 N6626UCramer Brett E · Sloughhouse, CABuilt 1963 · S/N 121 N6627JYellowstone Flying Club · Billings, MTBuilt 1968 · S/N 28-4927 N6627PMaddela Prabhuvaram J · El Mirage, AZBuilt 1959 · S/N 24-1750 N6627WSemprimoznik Jeffery J · Davenport, WABuilt 1965 · S/N 28-20724 N6628EPhillips Alan K · Junction City, ORBuilt 1979 · S/N M-2181 N6628JSiusta Donald W · Bryceville, FLS/N M-2182 N6628PRavich Vladimir · Fort Montgomery, NYBuilt 1960 · S/N 24-1751 N6628RD & K Aero · Elkhart, INBuilt 1974 · S/N M-1607 N6628WFigueroa Ruben E · Las Vegas, NVBuilt 1965 · S/N 28-20725

Back to AD 79-10-03 R2