Skip to content

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.

N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594 N2094ZSpak Andrew T · Thousand Oaks, CABuilt 1963 · S/N 15059894 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095RTyson John H · Melba, IDS/N 18255295 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N2095YJurca John · Punta Gorda, FLBuilt 1962 · S/N 17249595 N2095ZLoose Keith · Saint Helens, ORS/N 15059895 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N2096ZHammons Clayton W · Salome, AZBuilt 1963 · S/N 15059896 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330 N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N2097YWulff Jonathan P · Eaton Rapids, MIBuilt 1962 · S/N 17249597 N2097ZSchieferecke Jeanine · Topeka, KSBuilt 1963 · S/N 15059897 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2098YLevel Altitude LLC · Seward, NEBuilt 1962 · S/N 17249598 N20997Aerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17251217 N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204 N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008 N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826 N209LJCat Agri Aviation Inc · Walnut Ridge, ARS/N 36334 N209TOnele Dennis E · Central City, NES/N 15068531 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888

Back to AD 79-10-14 R1