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.
N7569GAirborne LLC · Wilmington, DEN7569PBrowne Donald K · Labelle, FLN756AAtp Aircraft 6 LLC · Wilmington, DEN756ALLange Robert Brandt · Newport Beach, CAN756AWLincoln Skyways Inc · Lincoln, CAN756BCBuchanan Bryan DBA · Gig Harbor, WAN756CCBrown Travis J · Lincoln, ALN756CKMckee Jay Russell · Baggs, WYN756CXCahill Brian H · Valley Center, CAN756CZRegistered aircraftN756DDAirade LLC · Davis, CAN756DFFroster David C · Ravenna, MIN756EBTak Holdings LLC · Pleasant View, TNN756EFTim Daniels Inc · Labelle, FLN756EMPacific Aircraft Management LLC · Tacoma, WAN756EVOyarzo Benjamin C · Cascade, IDN756EZBear Branch Hedeen LLC · Meridian, IDN756FRobertson Lisa O · Jackson, WYN756FCSunny Aviation Investments Inc · San Francisco, CAN756GAtp Aircraft 9 LLC · Wilmington, DEN756GEAbraham Curtis L · Byron, WYN756GLLawrence Cyril Leonard · Merced, CAN756GYLake Superior College · Duluth, MNN756GZGlasow Zachary · Klamath Falls, ORN756JBRocky Mountain Great Planes LLC · Loveland, CON756JLN756jl LLC · Virginia Beach, VAN756JPHjs Aviation LLC · Fort Collins, CON756JSRedline Engineering Inc · Greenwood, CAN756JVRufus Briar Inc · Willow Spring, NCN756JYLadnier Ronald R · Lone Tree, CON756KQTorgerson Kristofer · Knoxville, TNN756KSSmart Ray · Burbank, CAN756KVBeckert Richard D · Lake Stevens, WAN756KZEight Two Tango Inc · Winchester, VAN756LQC2c Investments LLC · St George, UTN756LRWingover Aviation Inc · Huntsville, ALN756MHKlingel Jeffery S · Byron Center, MIN756MNMoody Bible Institute Of Chicago · Spokane, WAN756NPAmerican Financial Services Inc · Las Vegas, NVN756NYKempton Larry G · Grand Junction, CON756PBQas Mile High LLC · Los Gatos, CAN756PPB&D Aviation LLC · Bowling Green, KYN756QKMiller Charles R · Montgomery, TXN756QXMayfield Kyle Barnes · Ukiah, CAN756RASan Diego Skylane LLC · San Diego, CAN756RFSky Kastle LLC · Milford, OHN756RNCrossbrook LLC · Willoughby, OHN756RPWayman Keith M · Longmont, CON756RVDobson Thomas J · Los Alamos, NMN756RWAir America Trading LLC · Phoenix, AZ
Back to AD 87-10-06 R1