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.
N79269Thomas Michael J · Eagle River, AKN7926GSpencer Aviation Inc · Delaware, OHN79270Jb Flight Services LLC · Carlsbad, NMN79274Olson Karl C · Bethel, MEN79275Briggeman Benjamin Andrew · Indianapolis, INN79276Burkholder Bruce B · Rockingham, VAN79277Foerster Keith A Trustee · Mound, MNN7927WFlight 4 U LLC · Lakeport, CAN79283Bradley Flying Association · Peoria, ILN79284Wright William T · Lenoir, NCN79286Aberdeen Pilots LLC · Boerne, TXN7928CCash Management Consulting LLC · Granite Springs, NYN7928LCox Robert Etan · Flippin, ARN7928PPeterson Jay O · Las Vegas, NVN7928YW Carney LLC · Ocala, FLN79296Ennis Michael J · Eminence, MON7929PSmh Aviation LLC · Johnstown, CON7929WStevenson Robert F · Wilmington, DEN7929YMasek Lawrence J · Cuyahoga Falls, OHN792AMeridian Aircraft LLC · Wilmington, DEN792ADBrown Daniel M · Altamont, NYN792BHuffman Myron · Felda, FLN792CCGavranovic William J Sr · Wharton, TXN792GWSmith Brothers Aviation LLC · Bryan, TXN792LRussell Robert Bruce · Clayton, GAN792MMclaughlin Theadolinda J · Brookings, SDN792MTParker Thomas L · Mount Vernon, ARN792NDUnd Aerospace Foundation · Grand Forks, NDN792SPUniversity Of Alaska Anchorage · Anchorage, AKN79300Cook Aero Services LLC · Tremonton, UTN79302Avco Patrol LLC · Lyndon, KSN79306La Partnership · Billings, MTN79308Alms Derek · Sullivan, ILN7930FIxi LLC · West Bloomfield, MIN7930LChavez Andrew · Pagosa Springs, CON7930NMerrill Erich W III · Corvallis, ORN7930PBotimer Douglas L · Fullerton, CAN7930WFleenor Robert S · Scottsburg, INN7930YShort Final LLC · Mooresville, NCN79310Erkie Bryan A · Denison, TXN79312Foote Jerry O · Unadilla, NYN79314Jacobson Wayne S · Bowbells, NDN79315Waco Aircraft Partners LLC · Mc Gregor, TXN79316C & B Flying Club LLC · Camden, ARFirst renewal noticeN79318Pace Glen M · Columbia, MSN7931HSale Reported · Palmer, AKSale reportedN7931LZundel Dana John · Watkins, CON7931NScott Lindbloom · Ft Wright, KYN7931VFerguson Brent M · Reynoldsburg, OHN7931YCannonball Trucking · Friendswood, TX
Back to AD 87-10-06 R1