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.
N82022Hard Luck Aviation LLC · Tok, AKN82023Rodriguez Richard V · Brooklyn, NYN8202CMoore Sharkie A · Houston, TXN8202ERegistered aircraftN8202WN8202w LLC · American Fork, UTN82035Troia Andrew · Homer, AKN8203DVans Holding LLC · Canton, OHN8203GWarne Samuel S · Salisbury, NCN8203KHandy Air Inc · Douglas, GAN8203NPope Jimmy M Jr · Eastover, NCN8203PDell John J · Saint Clair Shores, MIN8203WCarter Terry A · Clinton, ARN8203YMn98 LLC · Belview, MNN82044Chandler Air Service Inc · Chandler, AZN82045Paris Air Inc · Vero Beach, FLN82048Newton Property Leasing LLC · Greene, IAN8204GLowe Clinton V · Lake Point, UTN8204JKusa Aviation LLC · Beaumont, TXN8204NNielson Rex W · Pendleton, ORN8204WJeffery Gordon Paul III · Kirkland, WAN8204YBlue Steele LLC · Barnegat, NJN82053Kleinknecht Richard C · Burtchville, MIN82054Fusaro Ronald G · Westerly, RIN82057Morelli Michael L · Eagle River, AKN82058Hunt Brackston C · Elaine, ARN8205APilot Place LLC · Sarasota, FLN8205CHasting Grant William · Covington, WAN8205EChandler Air Service Inc · Chandler, AZN8205GYoung Charles D · Athens, TXN8205WShockey Michael J · Dumas, TXN82063Richards Brian W · Soldotna, AKN82064Wells Joseph E · Dorchester, SCN82065Yundt Joshua J · Wasilla, AKN82067Knutson Wayne R · Thompson, NDN8206BSandoval Joel · San Luis, AZN8206CCalvert Charles W · Ranger, TXN8206PMente Charles E · Ocala, FLN8206WMedia Stew LLC · Carson City, NVN8206YBauer Electric Inc · Winona, MNN82071Vintage Aircraft LLC · Leesville, SCN82075Miloud Chadd K · Fort Worth, TXN82076Kustatan Leasing LLC · Nikiski, AKN8207GKing Paul · Mount Holly, NJN8207NRohner Harlan G · Willmar, MNN8207PReed Thomas F · Wichita, KSN8207TColorado Aircraft Maintenance Solutions LLC · Denver, CON8207YTwinkie Air LLC · Colville, WAN82084Dorion David R · Asotin, WAN82085Read Lawton · Meredith, NHN8208EChamplain Island Hoppers · Burlington, VT
Back to AD 81-18-04 R2