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.
N9194DDaniels Daryl A · Warren, OHN9194EMoore Weston J · Juneau, AKN9194JStange Robert C · Toledo, OHN9194KHarry Philip · Asheville, NCN9194LRussell Keith M · Ivoryton, CTN9194VAlva Aviation LLC · Nacogdoches, TXN9194WWatson Paul F · Galloway, NJN9194YBanner Jeffrey D · Grove City, PAN9195JLau-Camarena Alvaro · Euless, TXN9195KWatson Joseph L Jr · Concord, NCN9195LStatewide Transportation LLC · Oklahoma City, OKN9195SBailey Thomas P · Cannelton, INN9195VHunter Robert J DBA · Montgomery, ALN9195WMcguire Aviation LLC · Kalispell, MTN91966Wings Over Texas Holdings LLC · Denton, TXN9196HLaplante Rene J · Bellingham, WAN9196JScarlett Seth T · Omaha, NEN9196LRunyon Larry · Susanville, CAN9196SSkyward Leasing Inc · Dallas, GAN9196VScherbarth Kenneth C · Eatonville, WAN9196WOklahoma State University · Stillwater, OKN9197BEsteban John G · Dublin, NHN9197JDifabio Jack F · Newtown, PAN9197LSchutze Curt K · Knoxville, TNN9197SEisenhaur Timothy · Wells, MEN91984A-Line LLC · Kent, WAN9198STolton Grant D · Republic, WAN9198WOklahoma State University · Stillwater, OKN91996Oklahoma State University · Stillwater, OKN9199AArgos Retail LLC · Mcallen, TXN9199ZOklahoma State University · Stillwater, OKN919ASchulze Thomas A · Bloomville, OHN919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN919CPCivil Air Patrol Inc · Maxwell Afb, ALN919DBPeterson Scott W · Garfield, KSN919DCDelaware Corp · Topping, VAN919DJPope James D · Lewiston, IDN919EPEpic Aviation Inc · New Smyrna Beach, FLN919GPRegistration Pending · Fairburn, GARegistration pendingN919HGRegistered aircraftN919JRByrne Ian E · Del Mar, CAN919KTAir One Helicopters LLC · Lincoln Park, MIN919LFUnmanned Aerial Research LLC · Freeport, FLN919PMRegistration Pending · Atmore, ALRegistration pendingN919RFRegion Flyers LLC · Valparaiso, INN919RVSamadhi Clear Mind Yoga Retreat LLC · San Marcos, TXN919TAAtp Aircraft 4 LLC · Wilmington, DEN919TCD & S Aviation LLC · Spring, TXN919UAKarably David P · Earleton, FLN919ZHouse Charles D · Tunkhannock, PA
Back to AD 81-18-04 R2