Registered aircraft · 1,686

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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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.

N763TCN42 Hy LLC · Kalispell, MTBuilt 1966 · S/N T210-0113 N764SAerotrans Management LLC · Mercer Island, WABuilt 1979 · S/N U20604957 N7685NFranklin Construction Inc · Chico, CAS/N 21063247 N769BSWells Donald T · Seattle, WABuilt 1968 · S/N U206-1251 N76BLBravo Lima Corp · Lakewood, COBuilt 1973 · S/N 21059808 N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569 N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357 N772RFSpencer John S · Indian, AKBuilt 1967 · S/N U206-0816 N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202 N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359 N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229 N775PSkydive Seneca Lake LLC · Ovid, NYBuilt 1966 · S/N U206-0769 N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480 N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224 N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194 N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156 N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835 N777SZMullen John J Jr Trustee · Henderson, NVBuilt 1970 · S/N 21059265 N778CWGarbati Thomas Jr · Waterford, CTBuilt 1981 · S/N U20606184 N7798NGebhard John M · Hartland, WIBuilt 1977 · S/N U20603718 N77CKRaiz Coaching LLC · Fort Worth, TXBuilt 1976 · S/N 20700343 N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846 N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235 N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580 N799PCRegistration Pending · Colorado Springs, CORegistration pendingBuilt 1966 · S/N T210-0178 N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615 N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697 N7ALFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21063261 N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936 N7RRTavan Richard M · Saratoga, CAS/N 21063468 N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593 N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792 N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780 N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031 N806HUAstra Engineering LLC · Twin Falls, IDBuilt 1979 · S/N U20605215 N808FSBradley Supply Company LLC · Mesquite, NVS/N 21061586 N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548 N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425 N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467 N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014 N811XArkoma Aviation LLC · Henryetta, OKBuilt 1966 · S/N T210-0068 N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429 N8130LPerfect 10 Roofing · Billings, MTS/N 21060617 N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438 N8139LWashburn Kyle A · Yukon, OKBuilt 1974 · S/N 21060626

Back to AD 71-09-07 R1