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.
N6707ZHood River Soaring Inc · Hood River, ORN6708BHartman Darrell W · Fish Lake Valley, NVN6708NBobby Stephen M · Dunkirk, MDN6708PWest Robert S · Gravois Mills, MON6708RStorey Timothy J · Camarillo, CAN6708SWininger Spencer C · Wichita, KSN6708UBlaedow Kyle R · Leesville, LAN6708XBaumbach James P · Lodi, CAN6709FMorning Star Transportation Inc · Dardanelle, ARN6709LBowlin Frank J · Santa Fe, NMN6709PRzewinski Leonard · Wading River, NYN670BBeck Mark A · Fort Wayne, INN670CSSilverhawk Aviation Academy LLC · Caldwell, IDN670EREmbry-Riddle Aeronautical University Inc · Prescott, AZN670LHFf22 LLC · Scottsdale, AZN670MAVan Anda Aviation LLC · Apopka, FLN670MLQualitair LLC Trustee · MichelstadtN670PWN670pw LLC · Monmouth Beach, NJN670RVSokoloski Gregory · Magnolia, TXN670SBDanles Enterprises LLC · Solvang, CAN670SCSpartan Education LLC · Tulsa, OKN670UBoard Of Regents Of The University Of Oklahoma · Norman, OKN670WBCt Cattle Co LLC · Wichita Falls, TXN6710BBarnard Matthew Bryan · Fort Worth, TXN6710NJohnson Kenneth W · Pine Bluff, ARN6710POdell Jeffrey S · Roseville, CAN6710UMonroe Flying Club Inc · Glen Carbon, ILN6710ZHeatwole Oren · Dayton, VAN6711Blue Heron Marine & Air LLC · Fredericksburg, TXN6711BJohnson Nathaniel D · Attalla, ALN6711GQuality Aviation Inc · Atlanta, GAN6711JFirecrest LLC · Holly Springs, MSN6711NHanna William R · Castle Rock, CON6711PPietroburgo Stephen M · Colville, WAN6711RAme Flight Holdings LLC · Oasis, IDN6711UUlassin Kyle B · Corvallis, ORN6711WBrinkman Michael R · Cleveland, TNN6711ZWoolslayer Joseph Patrick · Tulsa, OKN67123Spencer Lane Inc · Lewes, DEN6712AMcginnis Air LLC · Rising Star, TXN6712JF & F Flying Service Inc · Springfield, VAN6712USchell Kerry A · Arvada, CON6712YYellowcub LLC · Billings, MTN67135Aviators Next Door LLC · Newnan, GAN6713UHinds Casey L · Seattle, WAN6713VMclendon Donnie E · Winder, GAN6714LBrost Bryan L · Canistota, SDN6714NLawler Thomas W Jr · French Lick, INN6714WFriend Henry H · Hibbs, PAN6715DHargett David · San Juan, PR
Back to AD 81-18-04 R2