Registered aircraft · 567

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:73-26-07-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3') 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:73-26-07-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
  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:73-26-07-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
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.

N61JBSierra Foothill Properties LLC · Reno, NVBuilt 1979 · S/N 417 S.A.N620ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 379 N62375Scott Flying Service Inc · Bono, ARBuilt 1988 · S/N 806B N635TADynamic Spine Solutions LLC · Weston, MABuilt 1985 · S/N 458 S.A.N63NECareer Aviation Company Inc · Wilmington, DES/N AC763B N644EMAgrilogics Industries LLC · Dalhart, TXBuilt 1980 · S/N 758SA N64LGRed Star Aero Services LLC · Mobile, ALBuilt 1972 · S/N 240 N6611KMj Aviation Inc · Tuckerman, ARS/N 394B N661DPMaricopa Helicopter LLC · Fresno, CAS/N 798 S.A.N66FF210 Partners LLC · Lutz, FLBuilt 1980 · S/N 430 S.A.N66KAMullins Michael · Seaford, DES/N LJ-582 N671Tregoat LLC · Henderson, NVBuilt 2012 · S/N L4-596 N671AVUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC671 N673AVUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC673 N674NMMartin Nicolas · Rolling Hills, CABuilt 1974 · S/N 11226 N67WGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 96052 N681TCRockstar Air LLC · Waco, TXBuilt 1971 · S/N 6054 N6840TJkak Services LLC · Sheridan, WYBuilt 1982 · S/N 441-0299 N6851XUpper Peninsula Aviation LLC · Kingsford, MIBuilt 1981 · S/N 441-0212 N68CLMitzoom Montana LLC · Lakeside, MTBuilt 1981 · S/N 448 S.A.N690BHHoward Bradley D · Big Sky, MTS/N 11361 N690CFN A Corp · Scappoose, ORBuilt 1974 · S/N 11168 N690CPPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11451 N690DDTropeano Construction Inc · Ocala, FLBuilt 1974 · S/N 11159 N690GFBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 11357 N690HBPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11205 N690PLMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2004 · S/N 2 N690PTCritical Mass Aviation LLC · Coral Springs, FLBuilt 1975 · S/N 11252 N690SDWoodward Properties LLC · Kalispell, MTBuilt 1975 · S/N 11287 N690SGNeptune Aviation Services Inc · Missoula, MTBuilt 1974 · S/N 11146 N690TRKolob Canyons Air Services Inc · Wilmington, DEBuilt 1972 · S/N 11034 N691AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N AC-691 N692TKaskel Super Service LLC DBA · Evansville, INBuilt 1979 · S/N 11555 N695GHN695gh Inc Trustee · Wilmington, DES/N 96078 N695GKGulfstream Aviation LLC · West Glacier, MTBuilt 1982 · S/N 96032 N695JPGulfcomm 1000 LLC · Matthews, NCS/N 96024 N695MMM8 Aviation LLC · Raleigh, NCBuilt 1982 · S/N 96050 N695ZSanborn Map Company Inc · Colorado Springs, COBuilt 1984 · S/N 96089 N699RKDynamic Aircraft Consortium LLC · Tangent, ORBuilt 1979 · S/N T300 N700AAJensen Jay A · Bountiful, UTBuilt 2004 · S/N 1 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N700DALowrey Jonathan S · Jasper, INBuilt 1969 · S/N 140 N700WAJohnson William M · Wichita, KSBuilt 1979 · S/N 400SA N7065DValley Air Service · Caldwell, IDBuilt 1993 · S/N 1Z024-15 N708PCAustin Point Aviation LLC · Portland, ORBuilt 1980 · S/N 95023 N709TRAmeriflight LLC · Dfw Airport, TXS/N AC-709B N70PEGst Aviation LLC · Tucson, AZBuilt 1979 · S/N 416 S.A.N70WYBecker Flying Service Inc · Hartington, NEBuilt 1995 · S/N G6-127 N711MBBarrick Gold Of North America Inc · Henderson, NVBuilt 1979 · S/N 441-0116 N711VKDuggar Aviation LLC · Tontitown, ARBuilt 1969 · S/N 157

Back to AD 73-26-07 R3