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.

N1455YHelm Richard A · Buckeye, AZS/N 17249155 N1456FBeames Delbert A · Visalia, CABuilt 1966 · S/N 17254951 N1456SPremium Holdings LLC · Spokane, WABuilt 1976 · S/N 18265004 N1456YLeonardi William J · Jamesport, NYBuilt 1962 · S/N 17249156 N1457FAdvanced Aviation LLC · Pontiac, MIBuilt 1966 · S/N 17254952 N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457 N1457VSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1974 · S/N 17263594 N1458FMaltby Patrick W · Bath, MIS/N 17254953 N1458VMiles Aviation LLC · Thedford, NEBuilt 1974 · S/N 17263595 N1458YTln Aviation LLC · Stanwood, WABuilt 1962 · S/N 17249158 N1459EN Hollywood Optimist Club Youth & Comm Svc Fndtn · Van Nuys, CABuilt 1978 · S/N 17271007 N1459FGostecnik Gary · Brookshire, TXBuilt 1966 · S/N 17254954 N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N1459VRegistration Pending · Portsmouth, NHRegistration pendingBuilt 1974 · S/N 17263596 N1459YBriere Mark E · Mims, FLBuilt 1962 · S/N 17249159 N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745 N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549 N145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1460VCk Leasing Services LLC · Wilmington, DES/N 17263597 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1461QMarquez Christopher D · Fleming Island, FLBuilt 1971 · S/N 15072761 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N1461YKarpov Vladimir · Raymond, NES/N 17249161 N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430 N1462DWarner Aric D · Rosamond, CAS/N 20045 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1463DSorrell Edward S · Vero Beach, FLBuilt 1951 · S/N 20046 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1463FSun Aircraft Management LLC · Ormond Beach, FLBuilt 2005 · S/N 172S9895 N1464CEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S9897 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1465DHendrickson Elisabeth · Kerrick, MNBuilt 1951 · S/N 20080 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013 N1466UConcepcion Leonardo · Downey, CAS/N 17267133 N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603 N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845 N1467VLumpkin Aviation LLC · Dahlonega, GABuilt 1976 · S/N R1722194 N1468DAhrens David R · Guthrie Center, IABuilt 1951 · S/N 20051 N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446

Back to AD 79-10-14 R1