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.

N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N13HNAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13255 N13HWSikes Alan · Collins, GABuilt 1962 · S/N 1850290 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444 N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431 N13TATextron Aviation Inc · Wichita, KSS/N 17276111 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938 N13WTBentz George T · Missoula, MTBuilt 1973 · S/N 18262089 N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N14007Kga Aviation LLC · Alfred, MEBuilt 2005 · S/N 18281589 N14008Suburban Air Corp · Castro Valley, CABuilt 2005 · S/N 172S9886 N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1400HAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10410 N1400UTino Frank V Jr · Miami, FLBuilt 1960 · S/N 15059024 N1401DRegistered aircraftBuilt 1951 · S/N 19984 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897 N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962 N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102 N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898 N1403RMy Way Aviation LLC · Weston, FLS/N 172S9877 N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1404SRegistration Pending · Englewood, CORegistration pendingS/N 18264964 N14055Top Hand Inc · Laurel, MTBuilt 1952 · S/N 20937 N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318 N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N1407DFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10666 N1407SCaesar Wings LLC · Ubly, MIBuilt 1976 · S/N 18264967 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N14084Chizek Terry L · Marion, KSBuilt 1960 · S/N 17944 N1408BIasco Flight Training Inc · Redding, CABuilt 2006 · S/N 172S10429 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408DParks James M · Potsdam, NYBuilt 1951 · S/N 19991 N1408SFrickel Well Service LLC · Atkinson, NEBuilt 1976 · S/N 18264968 N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108 N1409DArcher William Todd · North Pole, AKBuilt 1951 · S/N 19992

Back to AD 79-10-14 R1