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.
N801SASpirit Air Inc · Salmon, IDN801SKStearns Scott A · Camarillo, CAN801SLZadow Ryszard Jerzy · Waller, TXN801SMMellott Samuel H · Mercersburg, PAN801STSfo Aviation LLC · Humacao, PRN801SW5b Aviation LLC · Duncan, OKN801TCSturgeon N C · Midland, TXN801THSouth Dakota State University · Brookings, SDN801VFisher James C Jr · Calhoun, GAN801VHYang Puyu · Palacios, TXN801VRFixed Wing Aviation LLC · Woods Cross, UTN801XMississippi State University · Starkville, MSN801XMMoore Don A · Royal, ARN801YLand Management Of New York LLC · Highland, NYN80202Barber Chester M · Haleyville, ALN80208High Country Aviation LLC · Lyman, WYN8020CThornton Jason G · El Dorado, KSN8020DStanley Steven D · Glasgow, MTN8020FAdams Blaine M · Litchfield, MNN8020PLovingood Max H · Naples, FLN8020YSnead State Community College · Boaz, ALN80210Atlanta Air Academy LLC · Kennesaw, GAN80213N80213 LLC · Wilmington, DEN80214Delta Capital Inc · Blair, NEN80216Hatbox LLC · Snohomish, WAN80218Tom Hassenfritz Equipment Co Inc · Mount Pleasant, IAN8021CSweet Kim · Rogers, ARN8021DArctic Super Pacer LLC · Anchorage, AKN8021NThibodeaux Bert J · Cedar Rapids, IAN8021YSterling Investment Services Inc · Batavia, ILN8022CMl Aviation Consulting LLC · Zephyrhills, FLN8022DZurovski David · Albion, NEN8022GAaron Arthur Harrison · Gold River, CAN8022NNiendorf John R · Friday Harbor, WAN8022RBlackwing Aviation LLC · Flower Mound, TXN8022WDean Newton Aviation LLC · Whitehouse Station, NJN8022YDanis Paul A · Woodinville, WAN80230Fly Nh Aviation LLC · Bow, NHN80238Hess Garrett J · Fullerton, CAN80239Borreson Anthony · Mariposa, CAN8023DSanchez Pascual G · Pantego, NCN8023NStafford Craig A · Tempe, AZN8023WHydroplane Ltd · Sherman Oaks, CAN80246Lincoln Skyways Inc · Lincoln, CAN80248Mtm Deland LLC · Deland, FLN8024GRedwing Aviation LLC · San Antonio, TXN8024NAll American Aviation Services Inc · Fayetteville, NCN8024PC Five Ranch Inc · Leoti, KSN8024QFox Leasing Group LLC · Hollywood, FLN8025Buergel Sandra J · East Aurora, NY
Back to AD 81-18-04 R2