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.
N8181NBald Eagle Flying Club · South Portland, MEN8181PTascosa Trail Inc · Gruver, TXN8181XStelling William F · Fairbury, NEN8182BMorgan William J · Plano, TXN8182ERed Arrow Aviation LLC · Santa Teresa, NMN8182NJlf Air Inc · Evansville, INN8182PFaulkner Ronnie L · Mount Ida, ARN8182WSwillen Richard Carl · Easley, SCN81830Wilkins Raymond E · Osceola, IAN8183CHendrie Derek · Venus, FLN8183DReabe Robert E · Waupun, WIN8183KSchleicher Richard A · Rch Palos Vrd, CAN8183NTucker Richard D · Locust, NCN8183XStill Jeffrey · Powder Springs, GAN81843Sorensen Paris K · Murrells Inlet, SCN81844Abrams Adrian L · Palmer, AKN8184CRouse Michael R · Wilson, NCN8184GAspire Aviation LLC · Farmingdale, NYN8184HPedersen Gregory S · Spring Hill, FLN8184WBaker John L · Killen, ALN8184XHarding Phyllis · Santa Rosa, CAN81853Hobbs Christopher · Truckee, CAN81858Strohauer Farms Inc · La Salle, CON8185ARiggin William J · Carterville, ILN8185NWright Edward J Jr · San Antonio, TXN81866Wellness Flight LLC · Sarasota, FLN8186CKelliher Tia Marie · Eagle River, AKN8186DAmg Industrial LLC · Ashburn, GAN8186KBlack Hills Soaring Club Inc · Rapid City, SDN8186NMorris Thomas L · Fairmont, WVN8186WStough Stephen A · Reno, NVN8186YHeiter Aviation Services LLC · Leesburg, INN81876Purcell Diane Diez · Baton Rouge, LAN81877Ansen Leasing Co · Boone, NCN81878Mcclave Wilkes III · Hanover, NHN8187DSchmidt Darrell · Kimberly, IDN8187HStover James L · Fredericksburg, VAN8187TLawdawg Property Rentals LLC · Williston, NDN8187WViroqua Area Flyers Inc · Viroqua, WIN8187XStevenson William E · Holton, KSN8187YWhite Jack S · Boone, NCFirst renewal noticeN81888Zion Thomas C · Middleboro, MAN8188CSlayden Steven M · Rhome, TXN8188JCrossbrook LLC · Willoughby, OHN8188PPurdy Bryan T · Bryant, ARN8188WBrewer Jordan L · Waynesboro, TNN8188YFly Anytime LLC · Kankakee, ILN81891Garnet Aviation LLC · Fort Worth, TXN81892Embry Kenneth · Nicholasville, KYN81894Yellow Dog Mgmt LLC · Fort Worth, TX
Back to AD 81-18-04 R2