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.

N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885 N2886CParks Walter G · Chugiak, AKBuilt 1954 · S/N 26429 N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986 N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886 N2886UVon Linsowe David J · Vero Beach, FLBuilt 1963 · S/N 17250486 N2887CKris Noone Air LLC · Wilmington, DEBuilt 1954 · S/N 26430 N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360 N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087 N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487 N2887SRobinson Andrew K · Pahrump, NVBuilt 1967 · S/N 15066787 N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287 N2888ESterett Terry Alan Jr · New Port Richey, FLBuilt 1982 · S/N 18268218 N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988 N2888KBooth William R Jr · Sterling, AKBuilt 1979 · S/N 18053119 N2888QChilds William C · Bridgeport, ALS/N 17259888 N2888UBodo Martin Trustee · Los Altos Hills, CABuilt 1963 · S/N 17250488 N2889CStowell Ronald A · Westminster, COBuilt 1954 · S/N 26432 N2889EWesellhigh LLC · West End, NCBuilt 1982 · S/N 18268219 N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989 N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089 N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489 N2889SKinter Christopher A · Kodiak, AKS/N 15066789 N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289 N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889 N288BTValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 18281607 N288CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281988 N288LSVacendak William A · Wasilla, AKS/N 32953 N288LTGlatczak Jerome · Schofield, WIBuilt 1963 · S/N 18255038 N288MCTomanec Jean · Victoria, TXBuilt 2002 · S/N 18281110 N288MESouth Dakota State University · Brookings, SDBuilt 2000 · S/N 172S8548 N288RWNortheastern Assets Holdings LLC · Dover, NHS/N 18267369 N288SCDelta Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13240 N288SPGlass Cockpit Aviation Inc · San Juan, PRBuilt 2006 · S/N 20608282 N288TMSlaba Mark E · Arcadia, FLBuilt 1967 · S/N 18258263 N2890CSpenchen Holdings LLC · Arnaudville, LAS/N 26433 N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990 N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890 N2890SKeyte Clinton W · Colfax, CABuilt 1967 · S/N 15066790 N2890URedley Andrew Scott · Maryville, TNBuilt 1963 · S/N 17250490 N2890VTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 15076313 N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890 N2891ARegistered aircraftBuilt 1953 · S/N 30091 N2891COconnell Edward P · Killingworth, CTBuilt 1954 · S/N 26434 N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991 N2891VSchaller Lee · New Athens, ILFirst renewal noticeBuilt 1974 · S/N 15076314 N2892CPatrick John A · Los Molinos, CABuilt 1954 · S/N 26435 N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363 N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992 N2892LSellers Michael E · Clam Gulch, AKBuilt 1967 · S/N 17256092 N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492

Back to AD 79-10-14 R1