AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N8808YAukes Brian E · Huxley, IAN8809Velociraptor Aviation LLC · Toney, ALN88092Verhulst Charles · Reva, SDN88098Merriwether David E · Whitesburg, GAN8809UDoyles Ag Services LLC · Two Buttes, CON880AFAmeriflyers Of Texas Inc · Addison, TXN880CBJ-Airco LLC · Nashville, TNN880CPCivil Air Patrol · Maxwell Afb, ALN880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN880FWebfoot Aviation LLC · Chesterfield, MON880FTFlorida Institute Of Technology · Melbourne, FLN880GLNew England Airlines Inc · Westerly, RIN880HCBadger Heli Corp · Wilmington, DEN880JGGray Richard D · White Stone, VAN880MABrekken Chris · Prescott, WIN880MXCool Breeze LLC · Shelbyville, KYN880PUPurdue University Trustees · West Lafayette, INN880RVHamilton David S · Locust Grove, GAN880THAviation Peter Corp Of New York · New York, NYN880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEN880XPAllen Ryan L · Lafayette, INN88108Nor-Wes Inc · Shreveport, LAN8810CGroenwegen Bruce C · Snohomish, WAN8810DNorman Timothy J · Tofte, MNN8810NShawl Robert M · Woodlake, CAN8810WLayne Andrew P · North Port, FLN88110Lovas Thomas A · Anchorage, AKN88118Richard Thomas W · Greenville, MSN88119Aysta Nathan P · Hermantown, MNN8811UAlder William D III · Athens, OHN8811YHutchinson Douglas E · Cle Elum, WAN88124West Aviation Inc · Creston, IAN88128Moore John T · Ward, ARN8812BSale Reported · Missoula, MTSale reportedN8812DSowders Darwin G · Robinson, TXN8812EHeiman Flying Services LLC · Summerfield, KSN8812YSpain Air LLC · Dadeville, ALN88130Harper Clayton E · Seabrook, TXN88134Morris William F B · Klamath Falls, ORN88135Reed Aviation Inc · Iota, LAN8813KPrecissi Flying Service Inc · Lodi, CAN8813MMja Flight LLC · Justin, TXN8813NLangton Shane A · Boise, IDN8813WOntiveros Carlos E · Prescott, AZN88140Green Flying Machine LLC · Prior Lake, MNN88144Hitchens Steven · Conesville, OHN88149Cheshire Brad F · Flower Mound, TXN8814FBas Part Sales LLC · Greeley, CON8814JCarey H Dwain · Cheyenne, WYN8814NMarshall Lance A · Portland, OR
Back to AD 81-18-04 R2