Registered aircraft · 56,580

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.

N3676CBoyce Walter Doug · Palmer, AKS/N 31175 N3676JKorinko Seana L · Rostraver Township, PABuilt 1966 · S/N 15064976 N3676UGregg Michael · Orlando, FLBuilt 1963 · S/N 18255076 N3677LBell Ellis E · Forrest City, ARBuilt 1965 · S/N 17253846 N3678JMorgan Daniel W · Keene, TXBuilt 1966 · S/N 15064978 N3678RCarl Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 17251566 N3678SMartone Douglas K · Windham, CTBuilt 1963 · S/N 17250878 N3678UCaven Dennis L · Santa Rosa, CABuilt 1963 · S/N 18255078 N3678YDozier Zach J · New Boston, TXBuilt 1963 · S/N 21058178 N3679UPowerhouse Coach Inc · Idaho Falls, IDBuilt 1963 · S/N 18255079 N367CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10711 N367MAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280649 N367TJFlorida Aerial Services Inc · Lutz, FLBuilt 1975 · S/N 18263721 N367TWTextron Aviation Inc · Wichita, KSS/N 172S13607 N3680CBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 31179 N3680SLubonovic Thomas M · New Carlisle, OHBuilt 1963 · S/N 17250880 N3680VAdams James W · Sioux Falls, SDBuilt 1975 · S/N 15076586 N3681JPence Northwest Aviation LLC · Salem, ORBuilt 1966 · S/N 15064981 N3681LBurton Walter E · Statesboro, GABuilt 1965 · S/N 17253850 N3681YJeff Blue Corp · Seminole, FLS/N 21058181 N3682CKiger Lance B · Prairieville, LAS/N 31181 N3682LRiseaero LLC · Florence, SCBuilt 1965 · S/N 17253851 N3682SPederstuen Ricky L · Hudson, WIBuilt 1963 · S/N 17250882 N3683JGuess Clayton L · Bushnell, FLBuilt 1966 · S/N 15064983 N3683VMcflight Aviation LLC · Highland, UTBuilt 1975 · S/N 15076588 N3684UToews Berton J · Casper, WYBuilt 1963 · S/N 18255084 N3685JBranson David F · Tucson, AZBuilt 1966 · S/N 15064985 N3685LBarber Richard S · Baker, NVBuilt 1965 · S/N 17253854 N3685SGarrison Randy L · Queen City, TXBuilt 1963 · S/N 17250885 N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185 N3686CSedwick William R · Anchorage, AKBuilt 1954 · S/N 31185 N3686JSeasun Aviation LLC · Miami, FLS/N 15064986 N3686SBurg David J · Oroville, CABuilt 1963 · S/N 17250886 N3686UEnvi Adventures LLC · Troutdale, ORBuilt 1963 · S/N 18255086 N3686YEllis Air LLC · Acworth, GAS/N 21058186 N3687JPacific Northwest Aeronautics Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 15064987 N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187 N3688LNamassivaya Nagaraju · Rexford, NYBuilt 1965 · S/N 17253857 N3688UTaylor Aviation Inc · Fort Benton, MTBuilt 1963 · S/N 18255088 N3688YHarris Beth · Albuquerque, NMS/N 21058188 N3689JInnovative Restoration Aviation LLC · Slidell, LAS/N 15064989 N3689VChvatal Daniel A · Jordan, MNBuilt 1975 · S/N 15076592 N368ABStryker Kevin · Ben Wheeler, TXBuilt 1968 · S/N 15069023 N368ESMindy Limited LLC · Muscatine, IABuilt 1997 · S/N 17280022 N368MState Of Montana · Helena, MTBuilt 1999 · S/N 18280598 N368MEWbl Air LLC · Minneapolis, MNBuilt 2000 · S/N 18280859 N3690JMcvay Joshua J · Longmont, COS/N 15064990 N3690LSmith Steve J · Magnolia, TXBuilt 1965 · S/N 17253859 N3691JS & S Aircraft LLC · Rathdrum, IDBuilt 1966 · S/N 15064991 N3691SBogan Jeremy · Rusk, TXS/N 17250891

Back to AD 79-10-14 R1