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.

N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760 N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960 N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360 N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160 N26613Coomes Thomas R · Hollis, OKBuilt 1998 · S/N 18280326 N26616Sea Wing LLC · Camarillo, CABuilt 1998 · S/N 18280329 N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102 N2661DWhite Theodore F · Willow, AKBuilt 1952 · S/N 20813 N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861 N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861 N2661UMoret Ronald P · Los Osos, CABuilt 1963 · S/N 17250261 N2661VParker Alan A · Visalia, CABuilt 1948 · S/N 18171 N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161 N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331 N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332 N2662DReakoff Jack L · Wiseman, AKBuilt 1952 · S/N 20814 N2662FGarmin International Inc · Olathe, KSBuilt 1998 · S/N 18280337 N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962 N2662JHanel Bruce · Placerville, CABuilt 1966 · S/N 15065662 N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862 N2662UDeal Sarah M · Saint Joseph, MIBuilt 1963 · S/N 17250262 N2662VPeck Kim O · Bolton, MABuilt 1974 · S/N 177RG0647 N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162 N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338 N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565 N2663DGuy Gary L · Fairbanks, AKBuilt 1952 · S/N 20815 N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863 N2663SMaclean Kenneth J · Northborough, MABuilt 1968 · S/N 337-0963 N2663UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250263 N2663VGuthrie Michael E · North Highlands, CABuilt 1948 · S/N 18173 N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643 N2664DGee Ryan S · Luverne, MNS/N 20816 N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964 N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298 N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648 N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865 N2666GForward Logistics LLC · New Castle, VAFirst renewal noticeBuilt 1959 · S/N 51966 N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866 N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966 N2666URegistration Pending · Decatur, TXRegistration pendingBuilt 1963 · S/N 17250266 N2666VWalden James F · Willcox, AZBuilt 1948 · S/N 18364 N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767 N2667GTundra Aviation Inc · Casselton, NDS/N 51967 N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367 N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347 N2667VPfunke Mark E · Chester, NJBuilt 1948 · S/N 18177 N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768 N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368

Back to AD 79-10-14 R1