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.
N7056WEustace Daryl R · Scottsboro, ALN7057LTri County Rentals And Sales Inc · Chiefland, FLN7057QMindy Limited LLC · Muscatine, IAN7057RContreras Robert G · Norman, OKN7057WWatkins Travis · Haughton, LAN70583Bult Equipment LLC · Monee, ILN7058GDc Aerial Photos Inc · Fredericksburg, VAN7058JStaggs Jerry A · Weatherford, TXN7058RMoss Harold E II · Overland, MON7058WRoman Donald M Jr · New Middletown, OHN7059State Of Alaska Department Of Public Safety · Anchorage, AKN70597Rodriguez Hulises · Chula Vista, CAN7059DSmith Andrew W · Willow, AKN7059GFrank Todd E · Corsicana, TXN7059HFly In Helicopters LLC · Florence, SCN7059PProx Jonathan P · Enterprise, ALN7059SParker Helicopter LLC · Watsonville, CAN7059WMartin Gerard A · Boston, KYN7059YPhill-Air Inc · Dover, DEN705ABHart Aviation LLC · Emory, TXN705BHKingfisher Air Inc · Kodiak, AKN705CFStanbridge Dale · Phoenix, AZN705CGLewis Scott M · Youngstown, OHN705FLSue Christina Alicia · San Antonio, TXN705JWTulare County Sheriff · Visalia, CAN705MMLeon Marco M · Broadlands, VAN705NDUnd Aerospace Foundation · Grand Forks, NDN705NRState Of Minnesota · Grand Rapids, MNN705PKahre Ryan · Blaine, WAN705RStatewide Contract Services LLC · Lowell, ORN705RBYakubinis William J · Charlotte, NCN705RVDetour LLC · Las Vegas, NVN705SFLet Industries LLC · Lewes, DEN705SRNewell Ryan A · Canton, OHN705TPhillips Gerald D · Lansing, MIN705TBAircraft Guaranty Corp Trustee · Oklahoma City, OKN705WHSky Craft LLC · Powell, OHN7060D3ird Dog Aircraft LLC · Billings, MTN7060NLansdowne Kevin · Sylva, NCN7060QPilot In Command Academy Inc · Miami, FLN7060WHorst Gregory J · Glen Burnie, MDN7061QMccutcheon Henry C · Frankfort, KYN7061YHoistad Flying Service Inc · Forman, NDN7062FGeorge'S Aviation Services Inc · Honolulu, HIN7062GNorthwoods Aviation LLC · Eagle River, WIN7062MWieler Jay H · Nome, AKFirst renewal noticeN7062PHryniewicki Walter E Jr · Chippewa Falls, WIN7062YFox Norman A · Maryville, TNN7063BNance Gary L · Fairbanks, AKN7063GL A H Eickhoff Farms Inc · Falls City, NE
Back to AD 87-10-06 R1