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.
N926CAWilmington Trust Co Trustee · Wilmington, DEN926CKFly By Numbers LLC · Tallahassee, FLN926CPCivil Air Patrol · Maxwell Afb, ALN926CRAero Tech Services Inc · Lititz, PAN926DGPerkins James W · Georgetown, TXN926DKSuthar Jay P · Danville, VAN926EZEcho Zulu LLC · Middletown, DEN926GG2 Aviation LLC · Franklin, WIN926JAMustang Sally Aviation LLC · Camden, SCN926JGGutwein Jan · Venice, FLN926JPJl Aviation LLC · Crestwood, KYN926MKToothman John C · Fairmont, WVN926MMGurewitz Alan · Thousand Oaks, CAN926MNPtw Consulting LLC · Atlanta, GAN926NLRemington Robert J · Sheboygan Falls, WIN926PACoco Aircraft Inc · Merritt Island, FLN926RUPottratz Dwane L · Beaverton, ORN926TCTango Charlie LLC · Gig Harbor, WAN926TEAnderson & Associates Inc · Little Rock, ARN926TMSwanson Richard E · Livermore, CON926WBBender Walter F Jr · Virginia Beach, VAN926WTArmadillo Aviation LLC · Scottsdale, AZN92704Gull Wing Flight LLC · Pt Pleas Bch, NJN9270DDowns Dennis D · Sterling, AKN9270KSlc Service Leasing Company LLC · Tipton, IAFirst renewal noticeN9270MMcmanus Nicholas A · Versailles, KYN9270SVinson Raymond R III · Mckinney, TXN9270VPhilippi Harrold Mark · Metairie, LAN92713Laughter John Eric · Brookhaven, GAN92719Mood Glen M · Ward Cove, AKN9271DGrasser Edward K · Palmer, AKN9271MCantelmi Richard L · Bethlehem, PAN9271RUpwind Aviation LLC · Mitchell, SDN9271SLife Is A Beech LLC · Commerce City, CON9271WMcelwee Jerilyn · South Riding, VAN92720Registration Pending · Champaign, ILRegistration pendingN92722Bryant David A · Walhalla, SCN92727Routh David A · New Richland, MNN9272DMummy Mountain Med LLC · Paradise Valley, AZN9272HBlackbird 71 LLC · Rockford, ILN9272JEast Fork Flyers LLC · Lu Verne, IAN9272LValira Aviation II LLC · Oakland, CAN9272MSearle Jacob · Kuna, IDN92731Plane@Work LLC · Blaine, MNN92732Hagman Jeffrey W · St Bonifacius, MNN92733Airborne Extreme LLC · Wasilla, AKN92736Larkin Marion J · Salome, AZN9273BAll-In Aviation LLC · Fort Myers, FLN9273JWhite Raymond · Jasper, ARN9273PNormark Nancy B · Weirsdale, FL
Back to AD 81-18-04 R2