AD 84-10-01 R1
Registered aircraft · 20,483
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-01-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-01-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-01-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-01-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.
N2752GZambarano Matthew C · South Hero, VTN2752QAnspaugh Bruce E Trustee · La Crescenta, CAN2753QFull Throttle Aviation LLC · Terlingua, TXN2753XStorer Charles E · Payette, IDN2754FOtter Mark E · Warrensburg, MON2755CR & B Aviation LLC · Oakland, MIN2755QBlessed With Wings LLC · Queen Creek, AZN2755XMcsheehy James B · Fallbrook, CAN2756QLett Brian R · Eden Prairie, MNN2757FNationwide Web Directory Ltd · Seattle, WAN2757QFive Seven Quebec Incorporated · Lake Stevens, WAN2758XAerotechniques LLC · South Kent, CTN275DMMaxfield Douglas R · Chico, CAN275FState Of Alaska Department Of Public Safety · Anchorage, AKN275HPRich Aviation Services LLC · Fort Worth, TXN275PTTruss Travis D · Stephenville, TXN2761GMartinell Justin E · Dell, MTN2762ADorman Richard E · Mesa, WAN2762FFreflite LLC · Wilmington, DEN2763FSeawings LLC · Holualoa, HIN2763XThompson Lyndon R · West Fargo, NDN2764QLong Donald G Jr · Gaston, ORN2765FStoup Lyndal K · Cordell, OKN2765XBa Aviation LLC · Anacortes, WAN2766FBrach Raymond S · Henderson, NVN2766QThree Airmigos LLC · New Port Richey, FLN2767GBrowns Valley Aviation LLC · Utica, KYN2768GCarrion John H · Colusa, CAN2768XMullett James L · Mccall, IDN2769FMatthews George W · Hillsboro, OHN2769GFraser Kevin J · Snohomish, WAN2769KMillennium Air Inc · Maurice, IAN2769QPrecision Truck Equipment Inc · Lansing, ILN276ACSmith Air Inc · Ukiah, CAN276AKSalo Mark W · Poulsbo, WAN276CKHuckabee Charles J · Seadrift, TXN276MEBoersma Rances LLC · Warden, WAN276TATextron Aviation Inc · Wichita, KSN2770FEmmons Jack E · Elizabeth City, NCN2771GWhitt Sana F III · East Quogue, NYN2772XBratten Douglas D · North Pole, AKN2773FAdriatic Holdings LLC · Cheyenne, WYN2773XLee Ty K · Anchorage, AKN2774QRdj Brothers Trucking Inc · Bigfork, MTN2774XElk Creek Investments LLC · Helena, MTN2775FJock Carl A Trustee · Roscommon, MIN2775QRay Chris J · Ironside, ORN2776FBabovic Slobodan · Elm Grove, WIN2776GOliver Charles D · Saint Albans, WVN2776XSmith James A III · Millerton, NY
Back to AD 84-10-01 R1