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.
N616SFAmelia Reid Aviation LLC · San Jose, CAN616SKSuperior Flying Services LLC · Superior, WIN616SRBarendregt Melvin E · Heyburn, IDN616TBChristofferson Kevin J · Fruita, CON616TKScano James · Gunter, TXN616VTNamendorf Michael · New Hyde Park, NYN616WDHalama Patrick J · Whitehall, WIN61700Torres Ramon L · Mulberry, FLN61701Jls Aviation LLC DBA · Fredericksburg, VAN61703Beising Steven · Las Vegas, NVN61704Glick Mervin L · Stanardsville, VAN61707Spartan National Holdings LLC · Missoula, MTN61709Caldwell Clifton · Sterling City, TXN6170JSeeler John A · Bristol, NHN6170MRothe Zachary W · Riverside, CAN6170PMaurer Bruce C · Power, MTN6170SNice Flight LLC · Medford, ORN6170YGe Org Advanced Systems LLC · Newton, NJN61710Bob Hoover Academy Inc · Salinas, CAN61713Miller Melanie L · Spanaway, WAN61718Ortman Bernard R · Bozeman, MTN6171HTyler Cherokee 235 LLC · Lindale, TXN61727Mays Gloria J · College Station, TXN6172DBlue Spruce Aviation LLC · Fairview Park, OHN61733Pan Air Flying Club Inc · Miami, FLN61737Executive Flight Institute LLC · Murrieta, CAN61738Finn Development LLC · Kaysville, UTN61739Southern Aero LLC · Homestead, FLN6173DArs Logistics LLC · Hackettstown, NJN6173JMinor Michael W · Summerland Key, FLN6173PSwenson James A · Lake Point, UTN6173QKinder Mark Edward · Bozeman, MTN6173WDiaz Jose O · Ramey, PRN61743Carruth John T · Danvers, MNN61748Zapata Raymond E · Cabo Rojo, PRN6174DOtoole Makena · Cordova, AKN6174JAloms Enterprises LLC · Marietta, GAN6174PAbernathy Larry D · Vernon, TXN6174RLaurel Highlands Aeronautical Academy · Latrobe, PAN61752Lee Robert Eric · Charleston, WVN61755K E F Enterprises · Plymouth, MAN61759Watkins Joe C · Albany, GAN6175GKimber 123 Holdings LLC · Morgantown, WVN6175TNewell John D · Cleveland, TXN6175ZSpot-Air LLC · Burlington, TXN61760Little Duane V · Puyallup, WAN61761Hawk Aviation Inc · Rush City, MNN61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLN61764Wohlgemuth Terry D · Squaw Valley, CAN61765Dean Mark T · Van Alstyne, TX
Back to AD 87-10-06 R1