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.
N595HPPickering Neil · Diamondhead, MSN595JCMcglochlin William M · Grand Junction, CON595KHarvey Air LLC · Doylestown, PAN595LMMontgomery Lorne D · Huntsville, TXN595MSClover Park Technical College · Lakewood, WAN595MTMiddle Tennessee State University · Murfreesboro, TNN595NDChristiansen Aviation LLC · Wilmington, DEN595PZSomid Resources LLC · Choudrant, LAN595RGGoulet Ronald · Toledo, ORN595RVYellow Bird Aviation LLC · Austin, ARN595SPSchool Of Missionary Aviation Technology · Ionia, MIN595THall Thomas E · Union City, TNN595TCExecutive Outcomes Pc · Jackson, TNN595TSArner Michael D · Tolland, CTN595VNess David A · Minneapolis, MNN595ZEvans Samuel F · Iuka, MSN5960FBonventre Michael J · Greentown, PAN5960PPalmenteri Louis J · Rhome, TXN5960QPlett Leo V · Liberal, KSN5960SOlson Phillip F · Tenino, WAN5960WNewman Matthew T · Cedar Park, TXN5960ZMielke James W · Wasilla, AKN5961JAtp Aircraft 2 LLC · Wilmington, DEN5962PD7l LLC · Meridian, IDN5962QNewell Robert T · Angel Fire, NMN5962USieber Eric P · Shelburne, VTN5962WMcmath Stephen S · Spokane Valley, WAN5962ZJet Mic LLC · Blossom, TXN5963QKatz Matthew · Los Angeles, CAN5963WPalm-Air Aviators LLC · Springville, UTN5963ZMcmahan Charles B · Gakona, AKN5964FDillard Gregory S · Columbus, MSN5964HRockdale Tiger Flight · Rockdale, TXN5964LHortman Walter J · Ivyland, PAN5964PDavis Darrell J · Livingston, TXN5964QLin Andrew Hsia · Huntingtown, MDN5964SMcnew John P · Brighton, CON5964UChandler Joseph R · Midlothian, TXN59652Aircraft Montana LLC · Helena, MTN5965LRegistered aircraftN5965PPearce Ricky A · Parsons, KSN5965SOverstreet James C · Montgomery, TXN5965WHadfield Brant C · Kirkwood, MOFirst renewal noticeN59669Sidney Morgan D · Gloucester, VAN5966FHalter George R 3rd · West Chester, PAN5966HStasiewicz John A · Milwaukee, WIN5966PMr Dent Inc · Manheim, PAN5966QFarwell Jason E · Lansing, KSN59678L&M Decuir Inc · Cottonport, LAN5967LRegistration Pending · Carolina, PRRegistration pending
Back to AD 81-18-04 R2