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.
N889JDByxbee John · Greenville, SCN889MSturza Allen J · Boyne City, MIN889MHExtreme Helicopter Service LLC · Alice, TXN889NDUnd Aerospace Foundation · Grand Forks, NDN889RMSands Kevin A · North Chili, NYN889SCCrawford Stevan L · Woodinville, WAN889SDMedary Aviation LLC · Brookings, SDN889SPLeading Edge Aviation Inc · Spencer, IAN889TJvs LLC · Santa Rosa, CAN889TTFlying Farmer LLC · Wilmington, DEN88ABBrown James L · Athens, ALN88ACSegerstrom William C · Sunriver, ORN88AHScott Cody · Eagle, CON88AKState Of Alaska · Anchorage, AKN88ALChristenson Lloyd Gregory · Side Lake, MNN88APLangdon Brian B · Newcastle, WAN88AVN88av LLC · Fort Myers, FLN88BELee George M · Queen City, TXN88BSBachman Jared R S · Elbert, CON88BWRegistered aircraftN88CTCameron John W · Canby, ORN88CVAllen David L · Sturgis, SDN88DAAnderson Darin D · Eatonville, WAN88DEMatta Figueroa Eduardo · Chapman, KSN88DKPitts Cabot J · Palmer, AKN88DRAkerson Charles J · Clarksville, TNN88EStarlite Aviation Technologies LLC · Las Vegas, NVN88EFPeyton Craig L · Rhinebeck, NYN88EHSale Reported · Pismo Beach, CASale reported, pending cancellationN88ETGelfan Russell A · Bellingham, WAN88FVandivort Aaron · Jacksonville, FLN88FBGeary Travis S · Viroqua, WIN88FCSandlapper Aviation Of De Inc · Bennington, VTN88FNSaline County Flyers Association LLC · Little Rock, ARN88FRAero Solutions Inc · Henderson, NVN88FXScronce Anthony W · Reno, NVN88GCHuth-Weiss Kathryn W · Prescott, AZN88GEGothreaux William A · Deridder, LAN88GGSchneck Doreen Trustee · Albany, GAN88GKSale Reported · Crestview, FLSale reportedN88GRLewis Brad D · Eugene, ORN88GT9q Partners LLC · West Caldwell, NJN88GVAllen Timothy J · Petersburgh, NYN88HGBagwell Harold G · Garner, NCN88HUSchultz Peter G · La Jolla, CAN88HYRegistered aircraftN88JCFarooq Tayab · Allen, TXN88JLSummit Concepts Inc · Wilmington, DEN88JVVan Grunsven Gerald B · Hillsboro, ORN88KAStefenelli Aviation N-Tr Inc Trustee · Attersee
Back to AD 81-18-04 R2