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.
N7090RMekolichick Jerry D · Whitehall, PAN7090WShipman Donald C · Interlochen, MIN7090YTucker Brandon · Rockledge, FLN7090ZSales Joe H · Seminole, TXN7091GSkylark Flight Training LLC · Wilmington, DEN7091VFreimund Chandler R · Big Horn, WYN7092FBerger Jeremy L · Noble, ILN7092GAmick Thomas C · Newberry, SCN7092PPaul Eric C · Grapevine, TXN7092RCosey William Vester Franklin · Inverness, FLN7092VTextor William E · Springfield, MON7092ZHollister Soaring Center LLC · Hollister, CAN7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeN7093FPockrus Pat B · Mineral Wells, TXN7093GAero Performance LLC · Scooba, MSN7093RKearns Joseph E · Worthington, OHN7093YMoore James S Trustee · Gray Court, SCN7093ZMid Continent Aircraft Corp · Hayti, MON7094DPotter Kent · Laurel, MTN7094GJohnson And Assoc · Davenport, IAN7094JTtwn Media Networks LLC · New York, NYN7094PS & M Aviation LLC · South Boston, VAN7094QRegistered aircraftN7094RWilson Flyers LLC · Rocky Mount, NCN7094VMason Gary W · Rockledge, FLN7095GHunter John Bockett · Riverton, NJN7095QWong Henry L III · Lake Forest, CAN7095RStevens Aircraft LLC · Morehead, KYN7095WByers Brady L · Newberg, ORN7096RHumphrey Richard K Jr · Abilene, TXN7096WN7096w LLC · Sherman Oaks, CAN7097GMurdy David C · Round Rock, TXN7097RFields Michael L · Rockwood, TNN7097WGlidepath Consulting LLC · Yuma, AZN7098NSearcy Moto-Air Inc · Searcy, ARN7098WFarabee Mechanical Inc · Hickman, NEFirst renewal noticeN7099CAnderson Richard Alan · Brainerd, MNN7099GHunt Howard E · Martinsville, ILN7099QVenaleck John T · Painesville, OHN7099YSparks Richard A · Wasilla, AKN709AMAirtrust LLC - 13 - Series 13 Trustee · Sheridan, WYN709BTAverett University · Danville, VAN709BWWolf Robert B · Boise, IDN709CAChristiansen Aviation LLC · Wilmington, DEN709CPCivil Air Patrol · Maxwell Afb, ALN709DBPowerhouse Detox Inc · Otis, ORN709DFGregoire Aviation Services LLC · New York, NYN709GCareer Pilot Training LLC · Wilmington, DEN709HSRokaboka Ltd · Mount Ida, ARFirst renewal noticeN709LAN709la LLC · Philadelphia, PA
Back to AD 87-10-06 R1