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.
N69WREllis Dustin D · El Campo, TXN69WTKeyt Jeffrey D · New Providence, NJN69WWThurmond Robert Lee · Blessing, TXN69WZBost Jeffrey T · New London, NCN69ZLHasenbein Bernie G · Wimauma, FLN6ABCenterline Holdings Inc · Camden, DEN6ADBurchinal Issac Newton · Paris, TXN6AHHurlbut Arthur G · Canton, NYN6ALTelfeyan John · Little Compton, RIN6ASVazquez Jose E Torres · Vega Baja, PRN6BCBest John · Cave Creek, AZN6BEZephyr Enterprises Inc · Wilmington, DEN6BNDevencenty Natalia · Pueblo, CON6BPSale Reported · Stockton, CASale reportedN6BQBeard Bradley A · Hanford, CAN6CFFalter Charles B · Cumberland, MDN6CGHarvey Benjamin A · Mountain View, CAN6CMSchultz Christopher A · Lake Forest, CAFirst renewal noticeN6CTVelocity 6 LLC · Sheridan, WYN6DGTimperman Eugene L · Cincinnati, OHN6DJRice Johnny D · Rosharon, TXN6DSSmith Dwight K · Canby, ORN6ECDraco Flight School Inc · Chino, CAN6EMHall Don L · Lakeland, FLN6ETSumner Gary · Knoxville, TNN6FARichards Donald D Jr · Cookeville, TNN6FDScud Air 6fd LLC · Morgan, UTN6FGSmith Timothy S · Kinston, NCN6FTBrotman Bruce · Morgantown, WVN6FVAlexis Asplundh Studio LLC · Atlantic Beach, FLN6GCLett Robert W · Dallas, TXN6GELemons Christopher P · Dexter, MON6GQCutsforth Robert S · Bellingham, WAN6GTVanguard Squadron Inc · Tea, SDN6GYYoung Gregory · Spring, TXN6HBHorneman Auric · Oakland, CAN6HCFriedrich James · Bakersfield, CAN6HMHenning Nancy E · Hardinsburg, KYN6HNTalbott Philip A · Galena, OHN6HPState Of Ohio · Columbus, OHN6HYGbh Aviation · Santa Monica, CAN6JPrewitt Scott S · King City, CAN6JJNemecek Larry · Canyon Lake, TXN6JXGallaher Graham William · Los Angeles, CAN6JZFaith Church Of Sherman · Sherman, TXN6KPPhillips Keith E · Port Orange, FLN6KTHawaii Pacific Aviation Inc · Kailua Kona, HIN6LAttinger Brian D · Mechanicsburg, PAN6LVEaton Raymond S · Plantation, FLN6MBSierra Whiskey Aircraft LLC · Oakland, CA
Back to AD 81-18-04 R2