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.
N5976BVarney Walter E · Charlotte, NCN5976EFunkhouser Dennis E · Fredericksburg, VAN5976LGoertz Anton Oscar · Santa Fe, NMN5976QEscobar Timothy · San Antonio, TXN5976XFandler Frederick · Shady Shores, TXN5977DCarr James C · Wasilla, AKN5977PAir-2-Eds LLC · Mesa, AZN5977SRothwell Rocky J · Valdosta, GAN5977UMorrow Robert H · Wyndmoor, PAN5977ZBrown Michael S · Kenai, AKN5978DWinkelman Ronald A · Chugiak, AKN5978LCorbin Thomas T · Titusville, FLN5978PMealey Patrick James Jude · Menlo Park, CAN5978QBauer Jared R · Sugar City, CON5979DVeal Tim S · Egegik, AKN5979QBlount Aviation LLC · Metairie, LAN5979SJohnson Jay W · Wichita, KSN5979UWings Of Grace Ministries Inc · Melbourne, FLN5979ZSchuster Timothy A · Carrington, NDN597AGSkywest Leasing Inc · St George, UTN597CBBrandon Air LLC · Valley Stream, NYN597DAb Prop Plane II LLC · Metairie, LAN597DCClark James D · Godley, TXN597DMBrandon Air LLC · Valley Stream, NYN597GCAg-Av8r Flying Services LLC · Brookline, NHN597JFDiamond Travel LLC · Olive Branch, MSN597JGKnoxville Flyers Inc · Knoxville, TNN597LDewitt Troy C · Lake Elmo, MNN597LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN597MTMiddle Tennessee State University · Murfreesboro, TNN597NDNicholas James Esch · Cedar Rapids, IAN597RARedtail Aviation LLC · Brookville, PAN597RVBeckley Jeff A · Windsor Heights, IAFirst renewal noticeN597SMoore Charles W · Lees Summit, MON597SCSpartan Education LLC · Tulsa, OKN597SPViolet Sparkle Pearl LLC · Hanover, NHN597TTTerrell David R · Smithville, TNN597TXCareer Track 2 LLC · Wilmington, DEN597WBaccas Christopher · Sun City Center, FLN5980UT A Aviation LLC · Tucson, AZN5980WCooke Carole J Trustee · Aguila, AZN5980ZOyster Flite Investments Inc · Wilmington, DEFirst renewal noticeN5981DPrecision Ag LLC · Kenmare, NDN5981LAnthony Allen J · Commerce Township, MIN5981STucker Mark R · Williamsburg, VAN5981UEast Sun Corp · Greensboro, NCN5981WLudwing Jonathan · Tompkinsville, KYN5981ZFell Donald M Trustee · Homer, AKN5982HClipper New Mexico LLC · Albuquerque, NMN5982SPercy Gary A · Wedderburn, OR
Back to AD 81-18-04 R2