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.
N642TXKenney Mark S · Channahon, ILN642TZBensen John A · Greenville, NYN642WPValiair Lc Trustee · Casper, WYN642WZMap Enterprises Inc · Mayfield, KYN64301B&R Aircraft LLC · Wadsworth, OHN64302Lanehart Zachary · Keo, ARN64303Acey Services LLC · Cumming, GAN64305Skyhaven Flying Club Inc · Dover, NHN64307Flywyo LLC · Kalispell, MTN64308Rein Robert G · Seattle, WAN64309Sveta Kadirova · Louisville, KYFirst renewal noticeN6430LSale Reported · Maysville, KYSale reportedN6430PMitchell Joseph Thomas · Powell Butte, ORN6430QMellor James F · Spanish Fork, UTN6430UWallace Dale E · Edison, NJN6431Cussen George J · Mount Prospect, ILN64313Aerial Scouting Solutions LLC · Sioux Center, IAN64314Registration Pending · New Bern, NCRegistration pendingN64317Spernak Airways Inc · Anchorage, AKFirst renewal noticeN6431QTruitt John M · Fishers, INN6431RCarothers Paul W · Russellville, ARN64325Varney Aviation LLC · Bangor, MEN64328Compass Aviation Inc · Shelby, NCN64329Bvs Aviation LLC · Burns, ORN6432JPeri Joshua E · Orting, WAN6432LBlount Charles L Sr · Gentry, ARN6432PAlvarez Frank · Hartford, WIN6432QWings Over Texas Holdings LLC · Denton, TXN6432RBreitbarth Brian · Canby, ORN6432VShortridge Randall R · Mesa, AZN6432WStoltzman Keith W · Amboy, MNN6432ZHamlin Timothy S · Bunker Hill, KSN64330Cornelius Beverly B · Merrill, WIN6433232 Leasing LLC · Englewood, CON64333Sawtooth Aviation LLC · Hovland, MNN64334Vrionides Polis G · Collinsville, CTN64335Cox Dennis J · Beach City, TXN64336Moore Joseph C · Farmers Branch, TXN6433QParatus Air Inc · Auburn, INN6433RGary R Kasper Motor Sales · Vassar, MIN6433TCole Richard J · Rolla, MON6433URensberger Scott C · Lake Jackson, TXN6433WLipinski Glen E · Chandler, AZN64340Spartan Aviation Services LLC · Parkland, FLN64344Pensacola Navy Flying Club Inc · Pensacola, FLN64345Sundstrom Jeffery V · Fresno, CAN6434LBiddlingmeier Donald W · Grosse Pointe Wood, MIN6434UCapps James E · Lillington, NCN6434WBlack Scorpion Nv LLC · Elko, NVN6435Weigle Timothy S · East Palestine, OH
Back to AD 81-18-04 R2