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.
N824ERegistered aircraftN824EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN824FFly Well Flying Club Inc · Roseville, MNN824GEaa Aviation Foundation Inc · Oshkosh, WIN824HAFeingersh Harry · Houston, TXN824JTRenfro Jacqueline L · Bethel, AKN824KJJohnson Kelly L · San Jose, CAN824KMGlover William S · Mount Pleasant, TXN824KSPlanelease LLC · Venice, CAN824LHSilent Investments LLC · Lake Havasu City, AZN824MCMidwest Aviation Services Inc · West Paducah, KYN824MMRelevant Enterprises Inc · Kalispell, MTN824NDUnd Aerospace Foundation · Grand Forks, NDN824NMMastrangelo Barry D · Cape May Ch, NJN824PAHot Wings Aviation LLC · Indianapolis, INN824PCHardee Jewell E · Keller, TXN824PJDowney Joseph E · University City, MON824PKReisdorfer Mark J · La Follette, TNN824RNCh Wings LLC · Arvada, CON824RVNielsen Matthew · Enterprise, ALN824SGAudenaert William N · Madison, ALN824SLMccaskie Stephen L · Jonestown, TXN824SVMarsh Victor W · Tracy, CAN824SWWatts Stanley A · Woodstock, GAN824TELhr44 Aviation LLC · Honey Brook, PAN824TFRegistered aircraftN824TRLand Air Enterprises Inc · Boynton Beach, FLN824VRDodson International Parts Inc · Rantoul, KSN824WSHampton Roads Charter Service · Chesapeake, VAN82502Christofferson Kevin · Fruita, CON82504Pentecost Benjamin I · Puyallup, WAN82505Kunkle Christopher · Santa Ynez, CAN82508Jones Matthew B · Wasilla, AKN8250CAcme Cub Training Inc · Anchorage, AKN8250NBruce James E · Greenfield, INN8250WMorehead Leonard E · Bryan, TXN8250YStoltz Kevin · Locust Grove, GAN82512Reed Charles H · Shelbyville, KYN82518Zeafla Randall Reis · Elizabethtown, KYN8251DSwenson Roger A · Pahrump, NVN8251FSchneider Ryan S · Colorado Springs, CON8251NLarue Jesse W · College Station, TXN8251PDefranco Ross A · Los Angeles, CAN8251SAirlife Aviation LLC · Elkridge, MDN8251VMarine Service Of Guntersville Inc · Guntersville, ALN8251WKeddis Moheb N · Fairfax, VAN82520Newman Scott W · Healdsburg, CAN82526Verbridge Gary · Williamson, NYFirst renewal noticeN8252CRoberts Dave C · Wibaux, MTN8252EMiami Flight Training LLC · Miami, FL
Back to AD 81-18-04 R2