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.

N23EFRapid Flyers LLC · Zionsville, INBuilt 2004 · S/N 172S9669 N23FOurada Mary E Trustee · Tulsa, OKBuilt 1962 · S/N 205-0073 N23FBHektner Douglas M · Girdwood, AKBuilt 1966 · S/N 185-1186 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035 N23GDPhoenix Composite Solutions LLC · Oscoda, MIBuilt 1978 · S/N 17270903 N23GVCongressional Flying Club · Gaithersburg, MDBuilt 1974 · S/N 17264594 N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050 N23JFSimba Air LLC · Mt Juliet, TNBuilt 1955 · S/N 26778 N23JRHerrera Pedro · Spring Branch, TXBuilt 1970 · S/N A1500259 N23KRUniversity Of Central Missouri · Warrensburg, MOBuilt 2023 · S/N 172S12952 N23LHHill Lawrence E · Marion, MTBuilt 1974 · S/N 18502433 N23LKHernandez Byron Jr · Buffalo, NYBuilt 1976 · S/N 185-03085 N23MZGulfstream Media LLC · Daytona Beach, FLBuilt 1972 · S/N 17260459 N23NPAia Foxtrot LLC · Henderson, NVBuilt 2023 · S/N 172S12984 N23RGRogers Ralph R · Winifred, MTBuilt 1964 · S/N 185-0693 N23SFTarhanick Timothy P · Livonia, MIBuilt 1971 · S/N 21059547 N23TLLottman Aviation LLC · Beatrice, NEBuilt 2004 · S/N 18281503 N23XGUsda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720163 N23YPBmf Jax LLC · Jacksonville, FLS/N 18281468 N23YRP R Parker Company Inc · Shreveport, LABuilt 2015 · S/N 18282379 N2400CFloyd William W · Anchorage, AKBuilt 1954 · S/N 30700 N2400DCrummett James F · Redding, CABuilt 1952 · S/N 20552 N2400QGc10 Aero LLC · Birmingham, ALBuilt 1966 · S/N 18257600 N2400RJenkins Clayton S · Brock, TXBuilt 1964 · S/N 18255500 N2400YClark Nikita C · Ontario, ORFirst renewal noticeBuilt 1962 · S/N 17249700 N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237 N2401AWhite Pat J · Wellington, TXBuilt 2006 · S/N 18281755 N2401GKidd Alexander P · Nashville, TNBuilt 1958 · S/N 51701 N2401JOne-Fifty Inc · Myerstown, PAS/N 15065501 N2401LDelta Ridge Farms LLC · Oak Grove, LAS/N 17255601 N2401RSky182 LLC · Eugene, ORS/N 18255501 N2401YBeauchamp William J · Rigby, IDBuilt 1962 · S/N 17249701 N2402LLehman Michael N · Lansing, KSBuilt 1966 · S/N 17255602 N2402RSmith Porter Allen · Aztec, NMBuilt 1964 · S/N 18255502 N2402XTeeter Ralph R · Caldwell, IDS/N 18256302 N2403GZeus Air Inc · Wilmington, DEBuilt 1958 · S/N 51703 N2403JCordell John M · Rochester, WABuilt 1966 · S/N 15065503 N2403LSeibert Richard L · Gibsonia, PABuilt 1966 · S/N 17255603 N2403QSkydive Harbor Springs Inc · Charlevoix, MIBuilt 1966 · S/N 18257603 N2403RDuck Dennis H · Jefferson City, TNBuilt 1964 · S/N 18255503 N2403UFloyd Carson K · Elberton, GABuilt 1962 · S/N 17250003 N2403YLarkin Timothy J · Pearland, TXBuilt 1962 · S/N 17249703 N2404CWatts Noah D · San Antonio, TXS/N 30704 N2404FDe Vries James S · Pacific, MOS/N 18051604 N2404LStalder David L · Amanda, OHBuilt 1966 · S/N 17255604 N2404QHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1966 · S/N 18257604 N2404YRegistration Pending · Rexburg, IDRegistration pending, pending cancellationBuilt 1962 · S/N 17249704 N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897 N2405GWarren Sam A Jr · Stanwood, WABuilt 1959 · S/N 51705 N2405SJohn L Lyle Aviation LLC · Ridgeland, MSBuilt 2006 · S/N 18281759

Back to AD 79-10-14 R1