Registered aircraft · 56,578

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-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1899CBarron Jon M · Perry, MOBuilt 1953 · S/N 26044 N1899MLoki Adventures LLC · Norwood, COBuilt 1975 · S/N 18264472 N1899QAlvord Jeffrey C · Tucker, GABuilt 1972 · S/N 177RG0299 N1899SBuon Volo LLC · Queen Creek, AZBuilt 1971 · S/N 177RG0045 N1899ZLarlee Coleman R · Millbrook, ALBuilt 1962 · S/N 2050099 N189CFRascher Lawrence · Pacific, MOS/N 18255465 N189CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281989 N189DCWorthan Gary T Trustee · Storm Lake, IABuilt 1976 · S/N 177RG0927 N189ERMustang Sally Aviation LLC · Camden, SCBuilt 1974 · S/N 15076412 N189JAPapillon Airways Inc · Kirkland, WABuilt 1969 · S/N 18259569 N189SElfdog Aviation LLC · New Franken, WIBuilt 1960 · S/N 52778 N189WMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17255907 N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059 N18ACHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9737 N18ADEzs Flyers LLC · Bonduel, WIBuilt 1972 · S/N 18261116 N18BBMuseum Of Flight Foundation · Seattle, WAFirst renewal noticeBuilt 1967 · S/N 337M0069 N18CDDorman Richard E · Mesa, WABuilt 1964 · S/N 18051402 N18CLAkro Attitudes Inc · Boynton Beach, FLS/N 52838 N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439 N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374 N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188 N18FAFisher Russell D · Vacaville, CAS/N 15061212 N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233 N18HBBuermann Henry · Brookfield, VTS/N 30912 N18HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281071 N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269 N18JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1980 · S/N 17274513 N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165 N18KKKhalil Kal Mohamed · Bedford, TXBuilt 1970 · S/N 15072224 N18LWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280403 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066 N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216 N18PMNoel Michael Patrick · Poplar Grove, ILS/N 18280300 N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795 N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N18TLCarey Nicolas J · Rosamond, CAS/N 18259225 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N18YZHightower Ronny · Blanchard, OKBuilt 1975 · S/N 15076721 N18ZPPierce Lestley R · Henderson, NVS/N 18263562 N19004N19004 LLC · Bend, ORBuilt 1972 · S/N 15074084 N19005Riddell Scott A · Winchester, KYBuilt 1972 · S/N 15074085 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162 N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000 N19011Kraus Tahj · Sarasota, FLS/N 15074090 N19015Jackson David W · El Cajon, CABuilt 1972 · S/N 15074093 N19018Dills Donald Edward · Tunnel Hill, GABuilt 1972 · S/N 15074096

Back to AD 79-10-14 R1