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.

N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212 N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540 N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640 N2440QTeanaway Ventures Consulting LLC · Cle Elum, WABuilt 2001 · S/N 18280937 N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040 N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740 N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983 N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879 N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802 N24429Pniak Robert J · Carmel Valley, CABuilt 2000 · S/N 18280700 N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2442GRegistration Pending · King Salmon, AKRegistration pendingBuilt 1959 · S/N 51742 N2442JOlson Lanny R · Huron, SDS/N 15065542 N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642 N2442QCoastal Business Systems Inc · Eureka, CABuilt 2001 · S/N 18280938 N2443DWeber Blake N · Sisters, ORBuilt 1952 · S/N 20595 N2443HSilver Star Jet LLC · Delafield, WIBuilt 2000 · S/N 18280702 N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643 N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643 N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543 N2443SGill Robert S · Prudhoe Bay, AKFirst renewal noticeBuilt 1967 · S/N 337-0743 N2443UIntream Companies LLC · Perryville, MOBuilt 1963 · S/N 17250043 N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122 N2444DBennett James E · Fredericksburg, TXBuilt 1952 · S/N 20596 N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644 N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544 N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344 N2444YConrad Matthew J · Dardenne Prairie, MOBuilt 1962 · S/N 17249744 N2445JBuzzard Aviation Inc · Freer, TXBuilt 2000 · S/N 20608095 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2445UPeachey Jason J · Milroy, PABuilt 1963 · S/N 17250045 N2445VN2445v Cessna Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280699 N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345 N2445YNew England Aircraft Detailing LLC · Webster, MAS/N 17249745 N2446ASkybound Aviation LLC · Bixby, OKBuilt 2000 · S/N 18280695 N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746 N2446DGreen Griffin LLC · Powell, OHS/N 20598 N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746 N2446REdgon Inc · Orlando, FLS/N 18280697 N2446SFerreby Thomas E · Stroudsburg, PABuilt 2000 · S/N 18280698 N2446XWashington State Patrol · Olympia, WABuilt 2000 · S/N 20608097 N2446YMcmickle Edward R · Riverside, CAS/N 17249746 N2446ZEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10118

Back to AD 79-10-14 R1