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.

N2823AMckinney Eric S · Hamersville, OHS/N 30023 N2823CJones Adam · Fairbanks, AKBuilt 1954 · S/N 26366 N2823E2lyons Enterprises LLC · Westlake, FLBuilt 1978 · S/N 17271335 N2823SSpark Aero LLC · Christiansburg, VABuilt 1965 · S/N 15062301 N2823UPowell Mark J · Chelsea, MIBuilt 1963 · S/N 17250423 N2823XSpectron Aviation Inc · West Boylston, MAS/N 17700223 N2824AStrode Lawrence W · Naknek, AKS/N 30024 N2824CReilly Richard J · St Paul, MNBuilt 1954 · S/N 26367 N2824QAv8 LLC · Davenport, IAS/N 17259824 N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724 N2825CSouza Clifford A · Pattersonville, NYBuilt 1954 · S/N 26368 N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925 N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425 N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825 N2826AConfer Gary R · Washougal, WABuilt 1953 · S/N 30026 N2826CSolstice Joshua A · Anchorage, AKS/N 26369 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N2828ALatham Cory D · Great Bend, KSS/N 30028 N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928 N2828KStephens Mark Edwin Trustee · Morgan Hill, CABuilt 1979 · S/N 18053091 N2828QJack Dixon · Haiku, HIBuilt 1971 · S/N 17259828 N2828XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700228 N2828YHooey Kevin M · Beaver Dams, NYBuilt 1962 · S/N 18253828 N2829EEverts Air Service Inc · Sarasota, FLBuilt 1978 · S/N 17271336 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2829QL & L Aviation LLC · Sidney, NEBuilt 1971 · S/N 17259829 N2829XHannam Michael J · Runnells, IABuilt 1967 · S/N 17700229 N2829YN2829y LLC · Longmont, COFirst renewal noticeBuilt 1962 · S/N 18253829 N282ABVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282139 N282CPWright Andrew T · Clyde, OHBuilt 1958 · S/N 51546 N282EL282el LLC · Pendleton, ORS/N 182-67682 N282ESC282es LLC · Tampa, FLBuilt 1996 · S/N 18280002 N282HDDavis Aviation LLC · Wilkesboro, NCBuilt 2005 · S/N 18281631 N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923 N282MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8540 N282MMMewmew Investment II LLC · Palo Alto, CABuilt 2019 · S/N 172S12247 N282MTMissig James M · Great River, NYBuilt 1997 · S/N 18280079 N282PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10750 N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068 N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466 N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030 N2830PSandpiper Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280593 N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430 N2830XCollins Stanley T · Elizabethtown, KYBuilt 1967 · S/N 17700230

Back to AD 79-10-14 R1