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.
N88KCMccarty Lyle H · Eugene, ORN88KFFore Shannon R · Wasilla, AKN88KMTsukii Toshikazu · Tucson, AZN88LDBryan William R · Kennesaw, GAN88LLLarrabee Consulting Group LLC · West Carrollton, OHN88LWRkj Enterprises · Bay City, TXN88MDWaage Matthew L · Elkhart Lake, WIN88MHCaitlyn Aviation LLC · Thousand Oaks, CAN88MRMarkus Stanley L · Oconomowoc, WIN88NESorjen Inc · Indian Trail, NCN88NGBakke Dale W · Yankton, SDN88NSDaniel Timidaiski · Mukilteo, WAN88PGBoyer Joseph A · Knoxville, TNN88PV400 Aviation LLC · Elkhart, INN88PYSegler Max D · Shoreview, MNN88QBAckerman Mendel R · Saint Matthews, SCN88QKLeal Felipe · Missouri City, TXN88QQJprg Aviation Inc · Orlando, FLN88RDLafayette Flying Service LLC · Lafayette, LAN88RFGrant Joseph P · Priest River, IDN88RVMyers Thomas A · Yamhill, ORN88RWRhoads Timothy C · Logan, NMN88RXWilson Ronald L · Lake City, FLN88SAAbc Aviation LLC · Oakland, CAN88SHSmith Jeary K · Greenfield, INN88SQBank Of Utah Owner Trustee · Salt Lake City, UTN88SSWasson Trevor J · Whitewater, MTN88SWBoline Lonny R · Lincoln, MEN88SYYamashita Bruce · Honolulu, HIN88TFHarts Joel D · Coffeyville, KSN88THEaa Aviation Foundation Inc · Oshkosh, WIN88TURv There Yet ? LLC · Lewes, DEN88UMSchefer Charles W L · Warrenton, VAN88VJWilson Kenny · Idaho Falls, IDN88VLMccullough Peter M · Evansville, INN88WCClobes Warren J · Evansville, WIN88WEWolfenden Enterprises Inc · Vero Beach, FLN88WHThomas Robert R · Rochester, MNN88WPN88wp LLC · Magnolia, TXN88WSChamberlain Donald R · Simsbury, CTN88WWQwest Aviation LLC · Edwardsburg, MIN88XKN-88xk Medical Aviation LLC · Kalispell, MTN88XTHallett Charles R · Fisherville, KYFirst renewal noticeN88YSOak Trees LLC · Wilmington, DEN88YWCharlston Michael M · Haleiwa, HIN88YZHultzapple Ted D · Farmington, NYN88ZGBrandt Gray L · San Diego, CAN88ZHLearn 2 Fly LLC · Cantonment, FLN89005Singh Fiyaad · Ocoee, FLN8900DRay Robert L · Palmer, AK
Back to AD 81-18-04 R2