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.
N9258WM And T Aviation LLC · Hampstead, MDN92591Florence Kenneth B · Silsbee, TXN92592Haggenmacher Scott · Jonesboro, ARN92595Bearfight Aviation LLC · Dover, DEN9259HBooke Phillip Austin · Anniston, ALN9259JDave Flight LLC · Mccook, NEN9259LWright Brandon · Cave City, KYN9259RAndiamo Aviation LLC · Stonecrest, GAN9259SAlles Harry · Greeley, CON925CBDhani Errol · Locust Grove, GAN925CPCivil Air Patrol · Maxwell Afb, ALN925DGNwi Drones LLC · Chesterton, INN925DSStarlight Technology Transfer Inc · Leesburg, VAN925EJBotsay Earl J · Diamondhead, MSN925EPEpic Aviation Inc · New Smyrna Beach, FLN925ERCrosswell Joe D · Springtown, TXN925HEWatson James C · Boerne, TXN925JLLudwig Jerry F · West Ossipee, NHN925KMRegistration Pending · Seguin, TXRegistration pendingN925MHAir America Imagery LLC · Daytona Beach, FLN925MKOates Douglas E · Elgin, SCN925MML A M Capital Management LLC · Sheridan, WYN925NEriksson Kurt R · Soldotna, AKN925PASkywest Leasing Inc · St George, UTN925PBRegistered aircraftN925PTPuddle Jumper Aviation LLC · Saginaw, MIN925RHVan Belle Christopher J · San Diego, CAN925RPFriel Paul Jr · Phoenixville, PAN925RSHall Jeffrey I · Broken Arrow, OKN925TARutan Aircraft Flying Experience · Waller, TXN925TEHarris David A · Cleves, OHN925VSzelc Jerome F · Gilbert, SCN925WLCrosswind Leasing LLC · Prescott, AZN925YZFranchetti Kevin · Manchester, MEN925ZKlimas David Todd · Mesa, AZN92605Sarratt Curtis H · Annapolis, MDN9260MRegistered aircraftN9260RVroom David H · Oro Valley, AZN9260SChristiansen Dee W · Kerrville, TXN9260TCanoace A Larned Enterprises Inc · Long Beach, CAN9260VBravo Aero LLC · Concord, NCN9260WFlo-Co2 · Gardendale, TXN92610Adventure Flight Aviation Inc · Springdale, ARN92617Stahl Raifen · Anchorage, AKN9261DBales Carson E · Wasilla, AKN9261HSchrom Frederick A · Carlisle, PAN9261JLear Steven J · Rockville, INN9261LDuran Nick R · Cleburne, TXN9261MPickett Trina M · Riverside, CAN9261PUdell Brian · Queen Creek, AZ
Back to AD 81-18-04 R2