Registered aircraft · 661

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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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.

N611RHMcneely Charter Service Inc · West Memphis, ARBuilt 1981 · S/N AT423 N61230Ag Solutions LLC · Garden City, KSBuilt 1994 · S/N G5-104 N6127LAg Solutions LLC · Satanta, KSBuilt 1994 · S/N G5-103 N6136ZAg Solutions LLC · Satanta, KSBuilt 1996 · S/N G6-138 N61374Hinkle Airspray Inc · Cavalier, NDBuilt 1994 · S/N G6-119 N613MAMarsh Aviation Co · Mesa, AZBuilt 1954 · S/N 522 N615DPRay Aircraft Leasing LLC · Tuscaloosa, ALBuilt 1976 · S/N 11317 N616KLFraser Peter · Powell Butte, ORBuilt 1973 · S/N 267 N616PSDena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1979 · S/N T316 N618SCArguelles Jamie D · El Paso, TXBuilt 1983 · S/N 618 N619BABemidji Aviation Services Inc · Bemidji, MNBuilt 1985 · S/N AC619B N61JBSierra Foothill Properties LLC · Reno, NVBuilt 1979 · S/N 417 S.A.N6207GBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N G10-178 N620ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 379 N62375Scott Flying Service Inc · Bono, ARBuilt 1988 · S/N 806B N62CNWiljan Holdings LLC · Lake Wales, FLBuilt 1980 · S/N 436 S.A.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 N649KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC-649 N64LGRed Star Aero Services LLC · Mobile, ALBuilt 1972 · S/N 240 N652KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1986 · S/N AC-652B 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 N680MDKolob Canyons Air Services Inc · Wilmington, DEBuilt 1991 · S/N AC776B N681TCRockstar Air LLC · Waco, TXBuilt 1971 · S/N 6054 N683LGGeorge Ladelle L · Ashley, NDBuilt 1978 · S/N 2441R N6840TJkak Services LLC · Sheridan, WYBuilt 1982 · S/N 441-0299 N6851XUpper Peninsula Aviation LLC · Kingsford, MIBuilt 1981 · S/N 441-0212 N685BARed Pine Company LLC · Bemidji, MNBuilt 1987 · S/N AC-685B 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 N690WWBemidji Aviation Services Inc · Bemidji, MNBuilt 1987 · S/N AC690B

Back to AD 84-10-06 R1