Skip to content

Registered aircraft · 4,000

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N1157KBistline Luke W · Tooele, UTS/N 25-0644 N1157LFurf Air Inc · Venice, FLBuilt 1982 · S/N 25-0654 N1157PPourcho William S · Bloomfield Hills, MIS/N 25-0647 N1157VJohnson Lisa Nicole · Klamath Falls, ORBuilt 1976 · S/N R1722125 N1158NAviation Endeavor Society LLC · Leander, TXBuilt 1981 · S/N 25-0648 N1159DZollars Thomas B · Dallas, TXBuilt 1982 · S/N 25-0652 N1159VShular Rodger D · Antelope, CABuilt 1976 · S/N R1722127 N115SDSky High Aviation LLC · Max, NDBuilt 1980 · S/N 250369 N1161BDean William R · Webster Springs, WVBuilt 1982 · S/N 25-0661 N1161MRed Climb Transition LLC · New York, NYBuilt 1982 · S/N 25-0657 N1161PN1161p LLC · Aspen, COBuilt 1982 · S/N 25-0658 N1162DUniversal Pacific Investments Corp · Portland, ORBuilt 1983 · S/N 25-0730 N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225 N1163ADodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 25-0666 N1163BCeltic Aviation LLC · Kalispell, MTBuilt 1982 · S/N 25-0667 N1164GGolonka Bryan · Locust Grove, GABuilt 1982 · S/N 25-0677 N1165DFlight Management Group LLC · Wadsworth, OHBuilt 1981 · S/N 25-0640 N1165GBreason Enterprises LLC · Dover, DEBuilt 1982 · S/N 25-0685 N1166DQba LLC · Poway, CABuilt 1983 · S/N 25-0720 N1166VClark John A · Windsor, CABuilt 1976 · S/N R1722130 N1166XEagle Aviation Inc · Tucson, AZBuilt 1975 · S/N 34-7570227 N1167HDawson Ron Jr · Garland, TXBuilt 1982 · S/N 25-0689 N1167JBas Part Sales LLC · Greeley, COS/N 25-0690 N1167NB52 Transports LLC · Altha, FLBuilt 1982 · S/N 25-0691 N1167UJohnson Thomas H · Garden City, UTBuilt 1982 · S/N 25-0692 N1167VBoard David N · Woodsfield, OHBuilt 1976 · S/N R1722131 N1167YShrestha Yuwaraj · Wichita, KSBuilt 1982 · S/N 25-0684 N1168BVitti Tyler · Ridgecrest, CABuilt 1982 · S/N 24-1303 N1168NCheung H Michael · Hudson, OHBuilt 1982 · S/N 25-0719 N1168SCnv Consulting LLC · West Jordan, UTBuilt 1982 · S/N 25-0694 N1168VGood Guys Flying Club LLC · Colorado Springs, COBuilt 1976 · S/N R1722132 N1168YRocking Jo Ranch Inc · Idaho Falls, IDBuilt 1982 · S/N 25-0696 N1169LGodwin Gerald R · Kountze, TXBuilt 1982 · S/N 25-0701 N1170UBolton Bruce P · Monroe, LAS/N 25-0702 N1170VPadgett Keith A · Bow, WABuilt 1976 · S/N R1722134 N1171GGivich Daniel D · Park City, UTBuilt 1982 · S/N 25-0706 N1172KDemo Salvage Inc · Calais, MEBuilt 1982 · S/N 25-0713 N1173GN9337h LLC · Orlando, FLBuilt 1982 · S/N 25-0724 N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231 N117KDCirrus Pompano Flyers Inc · Fort Lauderdale, FLBuilt 2000 · S/N 1072 N117RKAlon Guy · El Paso, TXBuilt 1979 · S/N 28R-7931068 N117SCJenkins Matthew A · Bend, ORS/N 28R-7703343 N118GFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N F33700068 N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236 N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137 N119GGYepes Hurtado Andres F · Lubbock, TXBuilt 1978 · S/N 28R-7931008 N119LMRegistered aircraftBuilt 1971 · S/N 22-0001 N119XUSale Reported · VentabrenSale reportedBuilt 1973 · S/N 0008 N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233 N11LSSmall Robert Lance · Fredericksburg, TXBuilt 1946 · S/N 1296

Back to AD 81-13-10 R1