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.
N7508RTaylor Devan A · Overland Park, KSN75091Pettet David · Brook, INN75093Turner Barry D II · Mccook, NEN75095Smith David Ross · Greensboro, NCN7509DPiggott Philip W · Peru, INN7509MFerry Douglas W · Santee, CAN7509PSuperbird Aviation LLC · Atlantic, IAN750AURunamuck LLC · New Orleans, LAN750CPCivil Air Patrol · Maxwell Afb, ALN750CZBinder Douglas B · Ithaca, NYN750DAParkhill Lawrence · Ojai, CAN750DS5 Pm Inc · Nampa, IDN750FYShuck Matthew M · Merrill, ORN750HKRegistration Pending · Lutz, FLRegistration pendingN750KOgk Aviation LLC · Mandan, NDN750NDUnd Aerospace Foundation · Grand Forks, NDN750RECarpenter Richard S · Goshen, OHN750RMMorse Ray Trustee · Cottage Grove, ORN750RTBoard Of Trustees Of Western Michigan University · Battle Creek, MIN750TSN949md LLC · Blossom, TXN750UOhio University · Albany, OHN750WLMiller John J · Canastota, NYN750XEvans Dale A · Green Cove Springs, FLN750XAMiller Peter D · Vernon, VTN750XSSchmalzel Douglass A · Allenton, MIN750YTwo Bar Aviation Inc · Lincoln, NEN751Pere Guy A · Cold Bay, AKN75105Mitchell Maverick LLC · Mitchell, SDN75108Haga Christian K · Thousand Oaks, CAN75109Knox Warrior Corporation · Mount Vernon, OHN7510EShier Aviation Corp DBA · San Diego, CAN7510FGrand Canyon Flyers LLC · Flagstaff, AZN7510HVan Wagner Aerial Media LLC · Hollywood, FLN7510JArmstrong Craig V · Casstown, OHN7510PMavco Corp · Lewes, DEN7510RNewton Hayden R · Charleston, MSN7510TSpitzer Helicopter LLC · Woodland Hills, CAN7510UCrop Doctor Aviation Inc · Hill City, KSN75110Triple R Aviation LLC · Cleburne, TXN75114Henrichs Debra L · Galloway, OHN75117Av8 LLC · Sandy, UTN7511ACouch Construction Co LLC · Palestine, TXN7511FEisenbrey Glen T · Greenbank, WAN7511WTtwn Media Networks LLC · New York, NYN75124Scott David A · Alliance, OHN75126Roth Darin · Max, NDN75127Amob 2 LLC · Baton Rouge, LAN7512CAirman Helicopter Inc · Fort Lauderdale, FLN7512FCulver Marc D · Anchorage, AKN7512JInfinity Aviation Group LLC · Nashua, NH
Back to AD 81-18-04 R2