AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N75091Pettet David · Brook, INN75093Turner Barry D II · Mccook, NEN75095Smith David Ross · Greensboro, NCN7509DPiggott Philip W · Peru, INN7509MFerry Douglas W · Santee, CAN7509PSuperbird Aviation LLC · Atlantic, IAN7509SBlueskys Inc · Wilmington, DEN750AWMagumbo Aviation LLC · Macomb, MIN750CZBinder Douglas B · Ithaca, NYN750GVTrak Inc · Gainesville, GAN750HKRegistration Pending · Lutz, FLRegistration pendingN750KOgk Aviation LLC · Mandan, NDN750NDUnd Aerospace Foundation · Grand Forks, NDN750RECarpenter Richard S · Goshen, OHN750TSN949md LLC · Blossom, TXN750UOhio University · Albany, OHN750XEvans Dale A · Green Cove Springs, FLN750YTwo 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, CAN7510HVan 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, TXN7511WTtwn Media Networks LLC · New York, NYN75124Scott David A · Alliance, OHN75126Roth Darin · Max, NDN75127Amob 2 LLC · Baton Rouge, LAN7512CAirman Helicopter Inc · Fort Lauderdale, FLN7512JInfinity Aviation Group LLC · Nashua, NHN7512NNative Range Capture Services Inc · Elko, NVN7512WNeblett Nathan · Fort Worth, TXN75130Tack Charles D · Apollo Beach, FLN75132Ferngulf Investments LLC · Loretto, MNN75133Parmer Curtis S · Greensboro, NCN75134N75134 LLC · Honolulu, HIN75136Montgomery Carson B · Divide, CON75138High Island Seamless Inc · Gaylord, MNN7513JHenslin Maja Blu · Wyoming, MNN7513KRenfro Jacqueline L · Bethel, AKN7513QFingerlakes Wing And Rotor LLC · Seneca Falls, NY
Back to AD 87-10-06 R1