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.
N86BJWings Over Texas Holdings LLC · Denton, TXN86BKBlue Raven Air LLC · Eagle River, AKN86BPMiller Jacob Gordon · Fountaintown, INN86BTTaylor Paul E · Hilo, HIN86CKFord Darin E · Colorado Springs, CON86CNWaldron Robert D · Willow, AKN86CSWarnock Tony J · Mobile, ALN86CYDawson J Stewart · Celina, TXN86CZHayes Kenya D · Pike Road, ALN86DPerry Richard Kevin · Titusville, FLN86DBMchugh John J · Camano Island, WAN86DJJakusz Donald G · Coppell, TXN86DMShine Dylan Patrick · Jupiter, FLN86DWWhidbey Flight Services LLC · Coupeville, WAN86ECParisi Mario · Grosse Ile, MIN86EFCic Aviation LLC · Wenatchee, WAN86FGGrantham George F · Bush, LAN86FPGateway Flight Center LLC · Port Lavaca, TXN86GCSpitzer Helicopter LLC · Woodland Hills, CAN86GMMcguire Michael D · Lake Stevens, WAN86GPNichols Clint T · Tehachapi, CAN86HFSkillman Michael W · Brookshire, TXN86HLGalpin Henry M · Kalispell, MTN86HTRegistered aircraftN86HWWalker James J · Santa Clara, CAN86HYBock Roger · Williamsville, ILN86HZAircraft Guaranty Corp Trustee · Oklahoma City, OKN86JDBurton Nicholas D · Clinton, TNN86JJFelda Farms LLC · Felda, FLN86JPZeitner Charles M · Palermo, CAN86KYMartin Jay L · Tijeras, NMN86LEHarris Robert W · Covington, TNN86LKKoinzan Flying Serv Inc · Elgin, NEN86LMFields David B · Midland, TXN86MARegistered aircraftN86MDLol Splash LLC · Helena, MTN86MKStinson Jeffrey S · The Villages, FLN86MLLam Aviation Inc · Los Altos Hills, CAN86MMMuir Malcolm D · Quincy, CAN86PTAlejandro Garduno · Livermore, CAN86RAAcrodocs LLC · Tallahassee, FLN86RHGross Richard · Phoenix, ORN86RLGreen Aviation LLC · Hedgesville, WVN86RPPetree Aviation LLC · Shreveport, LAN86RTInverted Aviation Inc · Walnut Cove, NCN86SADureiko Martin J · Miami, FLN86SMChase Aero LLC · Darrington, WAN86TDGuimont William P · Lynnwood, WAN86TFPickren Craig W · Batesville, ARN86THWeems Winceslas Scott · Columbia, SC
Back to AD 81-18-04 R2