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.

N3327SDavis Blake A · Bellevue, TXS/N 21059127 N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627 N3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTBuilt 1955 · S/N 32126 N3328ENorthwoods Air LLC · Orono, MES/N 17271505 N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944 N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946 N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947 N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948 N3329DWarren Mark W · Arlington, WABuilt 1955 · S/N 32127 N3329ERichards Erick F · Stamford, TXS/N 18268242 N3329FFerguson Ryan L · Fort Collins, COBuilt 1966 · S/N 18257329 N3329UDirectional Holdings LLC · Missoula, MTBuilt 1963 · S/N 18254729 N332CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12137 N332DGRaymond Jeffrey R · Fairbanks, AKBuilt 1976 · S/N 18503043 N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514 N332JRAdair Lawrence L Jr · Fountain Run, KYBuilt 1961 · S/N 18253722 N332MCClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13551 N332SCSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608332 N332SPMh Aviation LLC · Foster City, CABuilt 2020 · S/N 17281118 N3330DState Of Alaska · Kodiak, AKBuilt 1955 · S/N 32128 N3330EJarco Air LLC · Fitchburg, MABuilt 1978 · S/N 17271507 N3330FEmk Trans LLC · The Dalles, ORS/N 18257330 N3330JDownwind Three Six LLC · Murfreesboro, TNBuilt 1974 · S/N 18263456 N3330UWolford Alyson · Bonney Lake, WABuilt 1963 · S/N 18254730 N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330 N3331DKramer Donald J · Buffalo, MNBuilt 1955 · S/N 32129 N3332SFluckey Gary T · Homer, AKS/N 18502274 N3332TWilliams Darryl L · Medina, OHS/N 17700632 N3332UMing Greg A · Guymon, OKBuilt 1963 · S/N 18254732 N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033 N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333 N3334DRedford Daniel A · Wasilla, AKS/N 32132 N3334EJarmer Ryan F Trustee · San Diego, CABuilt 1978 · S/N 17271509 N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634 N3334YHarless Richard K · Battle Mountain, NVBuilt 1962 · S/N 18254334 N3335DWilson Zane D · Fairbanks, AKBuilt 1955 · S/N 32133 N3335FSocorro Meraz · El Paso, TXBuilt 1966 · S/N 18257335 N3335UFogle Kenneth J · Chagrin Falls, OHBuilt 1963 · S/N 18254735 N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136 N3336TBirch Point Ventures LLC · Virginia, MNS/N 18051494 N3337DSmooth Air LLC · Camas, WABuilt 1955 · S/N 32131 N3337EAltitude Aviation LLC · Lenoir, NCBuilt 1978 · S/N 17271510 N3337FAerolife Aviation LLC · Knox, INBuilt 1966 · S/N 18257337 N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137 N3338VAero-Tech Services Inc · Lititz, PABuilt 2025 · S/N 172S13307 N3339DSale Reported · Kalispell, MTSale reportedBuilt 1955 · S/N 32137 N3339FRegistered aircraftN-number assigned, not yet registeredS/N 17700600 N3339TBritt And Ashley Kieffer Farms · Weiner, ARS/N 17700639 N333ADRegistration Pending · Lynchburg, VARegistration pending, pending cancellationS/N 15078954 N333AFChickasha Wings Inc · Chickasha, OKBuilt 1972 · S/N 17260403

Back to AD 79-10-14 R1