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.

N3626JEa Cvg LLC · Erlanger, KYS/N 15064926 N3626LKoshar Robert E · Watervliet, MIBuilt 1965 · S/N 17253795 N3626VTorres Torres Angel G · Chesapeake, VABuilt 1975 · S/N 15076567 N3626YNb Ag Solutions Inc · Manila, ARBuilt 1963 · S/N 21058126 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N3627LGeorge Edward J · Highland Village, TXBuilt 1965 · S/N 17253796 N3627UStribling Tyron S · Lagrange, GABuilt 1963 · S/N 18255027 N3627YBarber Michael · Pagosa Springs, COS/N 21058127 N3628JLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15064928 N3628LThrasher Gary Phillip · Galena, OHBuilt 1965 · S/N 17253797 N3628SWright Way Air Venture LLC · Westville, INBuilt 1963 · S/N 17250828 N3629SBradley Christopher J · Left Hand, WVBuilt 1963 · S/N 17250829 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013 N362KTOverstreet Investments Inc · Boonville, MOBuilt 2018 · S/N 18283043 N362KWFliteco Holdings LLC · Lewes, DES/N 18260338 N362LKJackson Brian J · Anchorage, AKS/N 15076026 N362LULewis University · Romeoville, ILBuilt 2023 · S/N 172S12983 N362MEDesmond James M · Oceanside, CABuilt 2000 · S/N 18280851 N362PC362 Papa Charlie LLC · Spokane, WABuilt 1972 · S/N 18261242 N362QRegistered aircraftBuilt 2018 · S/N 172S12188 N362SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8779 N3630SFly Dogs LLC · Sunbury, OHBuilt 1963 · S/N 17250830 N3631CClark Mark R · Pullman, WABuilt 1954 · S/N 31129 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3631LMcveigh Ian T · Mansfield, TXS/N 17253800 N3631SJust Plane Fun 9m6 LLC · Lake Providence, LABuilt 1963 · S/N 17250831 N3631UBurden Richard M · Woodway, TXBuilt 1963 · S/N 18255031 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N3632JMitterling Richard H · Boothbay Harbor, MEBuilt 1966 · S/N 15064932 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3633JMicrokit Solutions LLC · Bridgeview, ILS/N 15064933 N3633UBrasher Cecil V Jr · Jamestown, NCBuilt 1963 · S/N 18255033 N3634JLuft Inc · North Fort Myers, FLBuilt 1966 · S/N 15064934 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803 N3635CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 31133 N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3635VTz Airways 1 LLC · Avon Park, FLBuilt 1975 · S/N 15076570 N36362Sale Reported · WitshireSale reported, pending cancellationBuilt 1955 · S/N 31691 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3636SGriesman Scott W · Sandy Valley, NVBuilt 1963 · S/N 17250836 N3636UVandeman Jack P · Norco, CABuilt 1963 · S/N 18255036 N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136 N3638JEngelskirger Karl D · Valley City, OHBuilt 1966 · S/N 15064938 N3638VHope Virginia L · Georgetown, OHS/N 15076571 N3639JPrima County Community College · Tucson, AZBuilt 1966 · S/N 15064939 N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808 N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039 N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139

Back to AD 79-10-14 R1