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.
N8557DWells Michael D · Wilton, MEN8557HLloyd Davis Inc · Brackettville, TXN8557PQuaal Ranch Inc · Sundance, WYN8557VBurton Michael B · Coweta, OKN8558LStar Ads Inc · Torrance, CAN8558PBaughman Kevin R · Avinger, TXN8558WEmerson Scott D · Roseville, CAN8558YFritsch Nathaniel · Ettrick, WIN8559NJohnson Arnold R · Mina, SDN8559PMcclean Adam D · Lakeport, CAN8559VHolub Mark A · Dallas, TXN8559WKelcher Colton C · Olympia, WAN8559ZMoss Aviation LLC · Howell, NJN855AVD & J Training Planes LLC · Logan, UTN855BDThompson Contracting Inc · Peachtree City, GAN855CPVector Air LLC · Erie, CON855GKUavionix Corp · Bigfork, MTN855LSAir First LLC · Kalispell, MTN855PCMcalee Dennis E · Defiance, MON855REBrowne Thomas J · Grass Valley, CAN855SPKirschner Joel D · Clarkesville, GAN855TSSteier Tim A · Blue Earth, MNN8560DMachovsky Andrew J · Mesa, AZN8560LKnutson Wayne R · Thompson, NDN8560MN8560m LLC · Rehoboth Beach, DEN8560WSafrit Christopher · Midlothian, TXN8561NPorter Louisa · San Diego, CAN8561VParatus Air Inc · Auburn, INN8561WMarble William R · Sparks, NVN8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeN8562NLorox Llp · Wishek, NDN8562PRegistration Pending · Waukee, IARegistration pendingN8563WRoche Daniel · Bellefonte, PAN8564FRmi Air LLC · Ocilla, GAN8564NEby Leo V · Clearville, PAN8564WBinns George E · Hackettstown, NJN8564YGingers Holdings Inc · Jacksonville, FLN8565PLynn Owen P · Vinemont, ALN8566NN8566n LLC · Briarwood, NYN8566PRicciardi Brian · Dennis, MAN8566VBrown Mill Ranch LLC · Lamar, CON8566YClarke George W III · Sierra Vista, AZN8567DBelleau Thomas D · Anchorage, AKN8567GRally Rocket LLC · Fort Collins, CON8567NWeekend Aviators Ltd · Herndon, VAN8567PJeewek Rita M Trustee · Parma, OHN8567WNielsen Peter K · Bellingham, WAN8567YJohnson Randy D · Becket, MAN8568CCavanaugh Darrel N · Wasilla, AKN8569CRudd Wayne G · Basalt, CO
Back to AD 87-10-06 R1