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.

N4068YPatkotak Hugh G · Anchorage, AKBuilt 1962 · S/N 1850268 N4069FDmac Aircraft LLC · Savannah, GABuilt 1958 · S/N 36969 N4069JFdp Productions LLC · Atlanta, GABuilt 1966 · S/N 15065369 N4069UPch Transportation LLC · Monterey, CABuilt 1965 · S/N 15061469 N406AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 185-0442 N406BNClover Crest II Inc · Key Largo, FLBuilt 1959 · S/N 56122 N406CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282440 N406DPWings & Blades LLC · Columbia Falls, MTS/N 18051805 N406EPChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11437 N406FRLunken Flight Training Center LLC · Cincinnati, OHS/N 17280297 N406GGCedar Creek Corp · Red Bluff, CABuilt 1967 · S/N 185-1154 N406JASpartan Education LLC · Tulsa, OKBuilt 2007 · S/N 172S10628 N406NWJohnson Aeronautics LLC · Billings, MTBuilt 1981 · S/N 18504244 N406PTMurray John J · Kalispell, MTBuilt 1981 · S/N 172RG0801 N406TAAircraft Unlimited Inc · Pierre, SDBuilt 2003 · S/N 172S9406 N406WMMcelvain Michael R · Billings, MTBuilt 1958 · S/N 51589 N407Lyford Charles A IV · Bellevue, WABuilt 1976 · S/N P3370251 N4070JClark Philip M · Caldwell, OHBuilt 1966 · S/N 15065370 N4070VWomack Jimmy R · Webb, ALBuilt 1948 · S/N 18402 N4071DNew Richard A · Deming, WABuilt 1958 · S/N 34771 N4071FQuebedeaux Steven R · Sunset, LABuilt 1958 · S/N 36971 N4071JMilhous Walter L · Carmichael, CABuilt 1966 · S/N 15065371 N4072VHauenstein Edgar D · Holden, MOBuilt 1948 · S/N 18404 N4072YCompton Douglas C · Heron, MTBuilt 1961 · S/N 185-0272 N4073DKarsell Kris J · Duluth, MNBuilt 1958 · S/N 34773 N4073FStebbins Craig S · Glendive, MTBuilt 1958 · S/N 36973 N4073UNew Entity Corp · Hardy, ARS/N 15061473 N4073VBryant Dorothy A · Arlington, SDBuilt 1948 · S/N 18405 N4074DDimitriadis Joseph T · Las Vegas, NVBuilt 1958 · S/N 34774 N4074YMcaleer John D · Aurora, ORBuilt 1961 · S/N 1850274 N4075FPrice Timothy C · Rancho Cucamonga, CABuilt 1958 · S/N 36975 N4075JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15065375 N4075UWright Joseph G · Medicine Lodge, KSBuilt 1965 · S/N 15061475 N4076FStebbins Robert A · Cookson, OKS/N 36976 N4076UKoehn David Scott · Orange Beach, ALS/N 15061476 N4076VPennington Charles A · Fort Smith, ARBuilt 1975 · S/N 15076691 N4076YPhillips Halvor A · Winnemucca, NVBuilt 1961 · S/N 185-0276 N4077D234kq LLC · Eagle, IDBuilt 1957 · S/N 34777 N4077ECalef Jere Trustee · Mojave, CABuilt 1965 · S/N 15061477 N4077FSolomon Joseph E Jr · Modesto, CABuilt 1958 · S/N 36977 N4077YWalker Air LLC · Charleston, WVBuilt 1977 · S/N 18265351 N4078DFinney James R · Howe, TXBuilt 1957 · S/N 34778 N4078FJanes Christopher D · Columbia, KYBuilt 1958 · S/N 36978 N4078UHoover Michael B · Ridgeland, WIBuilt 1965 · S/N 15061478 N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779 N4079FCovington Gary N · Midland, TXFirst renewal noticeBuilt 1958 · S/N 36979 N4079UScribner Jeffrey D · Upton, MEBuilt 1965 · S/N 15061479 N4079VGovednik Frank J · Nipomo, CABuilt 1948 · S/N 18411 N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937 N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444

Back to AD 79-10-14 R1