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.
N8272FMidwest National Flying Club Inc · Gladstone, MON8272HMorten Jesse L · Larimore, NDN8272RCooper Patrick R · Houston, TXN8272VSkybound Aviation LLC · Greensboro, NCN82731Hoecher Chris · Greeley, CON82732State Of Alaska · Anchorage, AKN82735State Of Alaska · Anchorage, AKN82736State Of Alaska · Anchorage, AKN82737Swiss Jack S · Anchorage, AKN8273AElon Aviation LLC · Burlington, NCN8273DDemuth John L · Juneau, AKN8273NSomboonsap Patanapong · Oakland Park, FLN8273VArctic Fox Aircraft LLC · Queen Creek, AZN82740Thomas Timothy W · Watsonville, CAN82741Stancil Joseph E Jr · Eagle River, AKN82743Up And Away Aviation LLC · Poughkeepsie, NYN82748Templeton Marie K Trustee · Carthage, MON82749Habersetzer Lon J · Yacolt, WAN8274EChristiansen Aviation LLC · Wilmington, DEN8274GMorris Robert B · Star Valley, AZN8274HThunderbird Aircraft Co · Bloomington, MNN8274JHunt Tyson B · Saratoga Springs, NYN8274NJln Aviation Services LLC · Avon, INN8274PVenticinque Raymond A · Cranston, RIN8274VSage Tech Flight Club LLC · Underwood, WAN8274WSleight Travis A · Southfield, MIN8274XBrown Archie W · Milford, NHN8274YTwinkie Transport LLC · Palm City, FLN82750Jabour Virginia · Port Orange, FLN82751Fly49 LLC · Palmer, AKN82754Lee Nathan · Athol, IDN82757Registration Pending · Fairmont, WVRegistration pendingN8275CLewis Payton S · Eupora, MSN8275DMoore Aviation Inc · Beaver Falls, PAN8275HMontgomery Aviation Corp · Montgomery, ALN8275JFlabob Airport LLC · Riverside, CAN8275NRollinger Dennis P · Plainfield, ILN8275UStout Kerrick L · New Richmond, OHFirst renewal noticeN82765Musumeci Paul N · Wilmington, DEN8276ASt Cloud Technical & Community College · Saint Cloud, MNN8276DMusko Richard · Plains, PAN8276ESkyview Aviation LLC · Tracy, CAN8276HDelalat Sean · San Diego, CAN8276JWiser Anthony J · Goodyear, AZN8276NShreffler Christine A · Ballwin, MON8276VNorthrop John B · Madison, WIN8276WTreleven Alfred Herbert IV · Tacoma, WAN8276XBnb LLC · Greenwich, CTN8276ZPar Five Enterprises LLC · Columbus, OHN82770O'Neil Chadwick P · Wells, ME
Back to AD 81-18-04 R2