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.
N8145VAscend Aviation LLC · Bountiful, UTN8145WNagel Thomas H · Tiffin, OHN81465Cornia Robert W · Long Beach, CAN8146AQuinn James F · Canton, MAFirst renewal noticeN8146CClark David A · Plainfield, INN8146WKemp Terry L · Lowell, ARN8146YSky West Aviation Inc Trustee · Albuquerque, NMN8147AMcelroy Aviation LLC · Carrollton, TXN8147JSt Rogers Holdings LLC · El Paso, TXN8147PHinson Jerry W · Nederland, TXN8147WFirst Landings Aviation LLC · Apopka, FLN8147XKahn David I · Briarcliff Manor, NYN8147YRietz Douglas W · Walla Walla, WAN81481Bci Aviation LLC · Dallas, TXN81483Woodward Dean · Salem, ORN8148JAir Winner LLC · Warner Robins, GAN8148LMeriden Aviation Center LLC · Meriden, CTN8148PYobs Robert E · Crozet, VAN8148ZWalker Melany A · Morro Bay, CAN81493N81493 LLC · Racine, WIN81497Skyward Air Inc · Los Angeles, CAN8149AKemp Roger W · Montgomery, ALN8149ENalrah LLC · Farmington Hills, MIN8149RRepublic Aviation Corp · Wilmington, DEFirst renewal noticeN8149TParis Air Inc · Vero Beach, FLN8149YMontague Lois L · Clio, MIN814ACAlpine Aviation Inc · Grass Valley, CAN814ATDot Aviation LLC · Wilmington, DEN814BJRancifer Rodney M · Lithonia, GAN814BKKilgore Brandyn L · Great Bend, KSN814BWPrunty Eugene W · Sewanee, TNN814CAChristiansen Aviation LLC · Wilmington, DEN814CBN814cb LLC · Dover, DEN814DEDickinson Dennis D · St Pete Beach, FLN814DPWestern Antique Aeroplane & Automobile Museum · Hood River, ORN814EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN814FGRidgeline Assets LLC · Wilmington, DEN814FKGlasswings Llp · Chanhassen, MNN814GPJackson Jefferey W · Milledgeville, GAN814HAIasco Flight Training Inc · Redding, CAN814JMLake Country Lodge · Port Alsworth, AKN814KCMoes Keith C · Independence, ORN814KSFargo Jet Center LLC · Fargo, NDN814KVSams Clarence F · Spicewood, TXN814MSteuk Patricia A Trustee · Middle Bass, OHN814MAHolder Airplane LLC · Greenville, SCN814MBBell Spencer P · Breckenridge, TXN814MMFerguson Charles · Daphne, ALN814MSJones Keegan L · Pendleton, ORFirst renewal noticeN814MVSterling Flight Training LLC · Jacksonville, FL
Back to AD 81-18-04 R2