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.
N536NDPhoenix East Aviation LLC · Daytona Beach, FLN536PUMetro Aircraft Co · Bloomington, MNN536SN5405a LLC · Beverly Hills, CAN536THLanier Equipment Leasing LLC · Gainesville, GAN536TPDownhill Aero LLC · Kalispell, MTN536XDel Rio Aviation Inc · Paso Robles, CAN53703University Of Michigan Flyers Inc · Ann Arbor, MIN5370FRegistered aircraftN5370HGodec David E · Waunakee, WIN5370LSouthern Colorado Flight Professionals LLC · Pueblo, CON5370PBlythe Anne T · Paso Robles, CAN5370TK.M. Biggs Inc · Lumberton, NCN5370WAllen Lanny Dean · Indianapolis, INN53713Haley Wendell B · Williamson, GAN53718Seals James E · Oxford, ALN53719Allen Scott P · Wellington, NVN5371FCummings Todd Bentley · Westfield, NCN5371HMacdonald Randall N · Weidman, MIN5371KExecutive Aviation LLC · Peoria, AZN5371QTimber Creek Flyers Lc · Albion, IAN53720Christiansen Aviation LLC · Wilmington, DEN53723Garthus Nels · Grafton, WIN53724Hackamore Equipment LLC · Prairie City, SDN53725Registration Pending · Honolulu, HIRegistration pendingN53726Bower Jessica L · Oshkosh, WIN53728Stinecipher Wilson C · Wasilla, AKN5372VCooper'S Hawk Aviation LLC · Rochester, MIN53730Vance Jason · Lufkin, TXN53735Vermont Flight Academy · South Burlington, VTN53737Diloreto Gregory T · Jupiter, FLN53738G&G Equipment LLC · Wasilla, AKN5373HMoore Jeffrey D · Blossvale, NYN5373LDavies Patrick · Chula, GAN5373THorizon Aviation LLC · Brooks, GAN5373YBush Dan S · Wasilla, AKN53740Gardner Robert J · Orwigsburg, PAN53742Mh Aviation Inc · Lancaster, CAN53744Tango Echo Aero LLC · Holly Lake Ranch, TXN53745Speth Kerry G · Oak Harbor, WAN53746Apollo 18 LLC · Tipp City, OHN53747Tenkey Investments LLC · Tulsa, OKN5374JMiles Brian R · Lake Jackson, TXN5374KApex Aircraft Leasing LLC · Anchorage, AKN5374LLund Chris J · Williston, NDFirst renewal noticeN5374PDeflorin David J · Harris, MNN5374TWeaver Stephen E · Enon, OHN5374ZMyers Kenneth Jerome · Haines, ORN53752Vectors West LLC · Coeur D Alene, IDN53753Erickson David R · West Point, UTN53754B U International Inc · Pierce, TX
Back to AD 81-18-04 R2