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.

N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172 N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288 N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N129MDMiller Glen S · Brenham, TXS/N 56430 N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012 N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291 N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038 N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732 N12GZBoettcher Aerial Co Inc · Beloit, KSBuilt 1974 · S/N 18801619 N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124 N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158 N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707 N12JIsland Aviators LLC · Grosse Ile, MIBuilt 1977 · S/N R1722455 N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841 N12JTHines Thomas J · Amsterdam, NYBuilt 1972 · S/N 15073955 N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915 N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853 N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774 N12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528 N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299 N12MMHigh Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15069873 N12NBFarrell Richard A · Dacono, COS/N 55815 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796 N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612 N12TYSewell Roger C · Meridian, IDBuilt 1960 · S/N 17248030 N12VMS & R Air Inc · Asheville, NCBuilt 1977 · S/N 21061697 N12WDHamburg Jeffrey · Corsica, SDS/N 57480 N12WRJjc Flyers LLC · Gladwin, MIBuilt 1975 · S/N 18263552 N13004Regnier Ryan A · Lockport, ILBuilt 1973 · S/N 17262439 N13008Midnite Sun Flying Club LLC · Eagle River, AKBuilt 1974 · S/N 17262441 N13009Laffey Joseph C · Saint Louis, MOBuilt 1973 · S/N 17262442 N1300QA-Cent Aviation Inc · Jacksonville, FLBuilt 1971 · S/N 15072600 N1300TVarnado Calvin M · Palmer, AKBuilt 1965 · S/N 17253731

Back to AD 79-10-14 R1