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.
N65537Aces High Aviation LLC · Long Beach, CAN6553DLlv Aviation LLC · Wilmington, DEN6553EZa Airport Rental LLC · Zanesville, OHN6553FArcwin Aero LLC · New Palestine, INN6553JCrestwater Properties LLC · Florence, SCN6553KSchaffner Christopher · Dunmore, WVN6553RRenkenberger Paul H · Yucaipa, CAN6553ULewis Orville W II · Memphis, TNN65546Baas Holdings LLC · Lewes, DEN6554CCharles City Aeronautics Inc · Charles City, IAN6554DHancock Jeffrey D · Delta, CON6554LN6554l LLC · Cheyenne, WYN6554WTpc Air LLC · Colleyville, TXN65550Haltom Gary D · Alva, OKN65551Riverside Flight Center Inc · Tulsa, OKN65557Classic Aircraft LLC · South Bend, INN6555JTeton Leasing LLC · Pocatello, IDN6555PBig Wings Inc · Delavan, MNN6555WDeeter George E · Chillicothe, OHN65561Wisconsin Aviation Inc · Watertown, WIN65563Darcy Aviation LLC · Danbury, CTN65567Skylane Sky LLC · North Palm Beach, FLN6556BLewis Joseph M · Huntington Beach, CAFirst renewal noticeN6556HRyco LLC · Lusk, WYN6556JJabco Inc · Weston, IDN6556UQoc Innovations LLC · Fall River, WIN6556WMontagnino James A · Saratoga Springs, NYN65572Rucinski Edward A · Climax, NCN65575Flight Training Aircraft LLC · Wilmington, DEN6557HRiverside Flight Academy LLC · Riverside, CAN6557JAsd LLC · Lebanon, NJN6557PBs Airlines LLC · Wahpeton, NDN6557UAtalla Mark S · Woodford, VAN6557WFrederick Darin L · Star, IDN65582Curley Keron P · Rockaway Park, NYN65583Meridian Airport Authority · Meridian, MSN65584G And M Aircraft Inc · Wheat Ridge, CON65586Sunstate Aviation Inc · Kissimmee, FLN65587Wings Over Texas Holdings LLC · Denton, TXN6558EZata Group LLC · North Little Rock, ARN6558JKarr Dennis R · Clyde, OHN6558UReed Gina D · Starkville, MSN6558WShirley Hills Aviation LLC · Macon, GAN65592Cohen Frederick I Trustee · Tulsa, OKN6559PFitzpatrick Derek J · Murrieta, CAN6559WHarrison Michael W DBA · Lewisville, IDN655AStrough Jacob L · Twin Falls, IDN655ACAuxier David R · Baker City, ORN655AGSkywest Leasing Inc · St George, UTN655CLRomuald David L · Newnan, GA
Back to AD 81-18-04 R2