Registered aircraft · 561

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:78-25-08-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:78-25-08-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:78-25-08-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:78-25-08-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:78-25-08-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:78-25-08-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.

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 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 N716CCRichmond Wheeler LLC · Marshfield, WIBuilt 1981 · S/N 441-0213 N716SMConquest Flight LLC · Pottstown, PABuilt 1977 · S/N 441-0004 N718EEN718ee LLC · Missoula, MTBuilt 1978 · S/N 718SA N725JTCorsair Enterprises Inc · Wilmington, DEBuilt 1981 · S/N 451 S.A.N725SVTtc Aircraft Leasing Inc · Decatur, TXBuilt 1978 · S/N 441-0051 N727DPTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTS/N AT039

Back to AD 78-25-08 R3