AD 84-10-06 R1
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
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.
N691AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN692TKaskel Super Service LLC DBA · Evansville, INN695FABank Of Utah Trustee · Salt Lake City, UTN695GHN695gh Inc Trustee · Wilmington, DEN695JPGulfcomm 1000 LLC · Matthews, NCN695MMM8 Aviation LLC · Raleigh, NCN695RTCommander Sc LLC · Mount Pleasant, SCN695TRRainey Air LLC · Bronwood, GAN695ZSanborn Map Company Inc · Colorado Springs, CON699RKDynamic Aircraft Consortium LLC · Tangent, ORN700AAJensen Jay A · Bountiful, UTN700BAAviation Inventory Resources Inc · Alvarado, TXN700DALowrey Jonathan S · Jasper, INN700WAJohnson William M · Wichita, KSN7065DValley Air Service · Caldwell, IDN708PCAustin Point Aviation LLC · Portland, ORN709TRAmeriflight LLC · Dfw Airport, TXN70PEGst Aviation LLC · Tucson, AZN70WYBecker Flying Service Inc · Hartington, NEN711MBBarrick Gold Of North America Inc · Henderson, NVN711VKDuggar Aviation LLC · Tontitown, ARN716CCRichmond Wheeler LLC · Marshfield, WIN716SMConquest Flight LLC · Pottstown, PAN718EEN718ee LLC · Missoula, MTN725JTCorsair Enterprises Inc · Wilmington, DEN725SVTtc Aircraft Leasing Inc · Decatur, TXN727DPTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTN727TPAudubon Air Of Louisiana LLC · Bossier City, LAN728FNAustin Bill DBA · Sparta, TNN731EAlaskan Air Charter LLC · Anchorage, AKN731TFTwo Friends Leasing LLC · Key West, FLN733BHCareer Aviation Company Inc · Wilmington, DEN741FNAir 1st Aviation Co Of Ok · Tulsa, OKN746KAKolob Canyons Air Services Inc · Wilmington, DEN746MAPacific Aircraft Services LLC · Saint Helens, ORN7501EFranklin Dirk W · Beaumont, TXN750CAQualitair LLC Trustee · MichchelstadtN751BRPonderosa Aviation LLC · Safford, AZN751TRCareer Aviation Company Inc · Wilmington, DEN752ASierra Aeronautics LLC · Franklin, KYN753AKDh Leasing LLC · Juneau, AKN753TRCareer Aviation Co Inc · Wilmington, DEN758XPParaclete Aviation LLC · Raeford, NCN75MXNational Test Pilot School · Mojave, CAN760BFHeritage Ag LLC · Lakeview, MIN762JC21 Luna LLC · Phoenix, AZN762VM5-T Aviation LLC · Eunice, LAN763LDBadil-Abish Thomasena · Spring, TXN769KLCbg LLC · Wilsonville, ORN76WAFlying A Flight Service LLC · Safford, AZ
Back to AD 84-10-06 R1