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.
N8715LScott Ts Ag Flyin Inc · Colquitt, GAN8715NKenmore Crew Leasing Inc Trustee · Bellingham, WAN8716MWilliams Excavating Inc · Partlow, VAN8716NWeiss Ariel · Bisbee, AZN8716WIts Just Plane Fun LLC · Gilbert, AZN8717CBristow Leonard B · Damar, KSN8717VSepko Joseph M III · Mebane, NCN8717YParker Meyers And Roth Inc · Morgan Hill, CAN8718DSlaughter James M Jr · Houston, TXN8718MGilson David R · New Port Richey, FLN8718NKelly Bradford S · Bedford, NHN8718VBecker Chris H · Panama City, FLN8718WB Max Aviation LLC · Mesa, AZN8719FKinzie Wayne · Alva, OKN8719VBluemel Steve · Auburntown, TNN871ACAri Ben Aviator Inc · Fort Pierce, FLN871CCUeckert Russell N · Abilene, TXN871CGBunting Cameron E · Lake City, FLN871CPRedstone Arsenal Flying Activity · Redstone, ALN871DMId Air LLC · Apopka, FLN871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN871FFunk Kevin A · Crescent City, FLN871FBFreebird Leasing Group LLC · Sarasota, FLN871MAN2634mm LLC · Farmingdale, NYN8720MHulme Aviation LLC · Gilbert, AZN8720NHogan David A · La Crosse, WIN8720WKerklo Michael W · Seville, OHN8721NCobe Aviation LLC · Miller, SDN8721VEliasquevici Abrao · Ocala, FLN8722CMayhew Oliver C Jr · Blairs, VAN8722DWirthlin Donald K · Sierra Vista, AZN8722NKrueger Sandra J · Chicago, ILN8723COracle Aviation LLC · Omaha, NEN8723ECronk Howard J · Council Bluffs, IAN8723ZKnapp James A Trustee · Casa Grande, AZN8724Fairhope Decathalon LLC · Fairhope, ALN8724DMoe Daniel N · Mukilteo, WAN8724EDcs School Of Flying LLC · York, PAN8724FDel Rio Aviation Inc · Paso Robles, CAN8724MKleiber Timothy D · Independence, KSN8724NSea 2 Sea LLC · Cantonment, FLN8724VVintage Wings Aircraft LLC · Centerpoint, INN8724WFrench Loren C · Gypsum, CON8725CDavis Byron J · Anchorage, AKN8725ERrr Transportation LLC · Oneonta, ALFirst renewal noticeN8725MFix Janice M · Crete, NEN8725YPerkins E G Jr · Greenwood, MSN87269Clint Aaron Aviation LLC · Columbus, GAN8726CRicco Umberto · Chicago, ILN8726DWheeler Corey L · Lakeport, CA
Back to AD 81-18-04 R2