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.
N8714FDown East Emergency Medicine Institute · Orono, MEN8714MCole Leonard O III · Sunrise Beach, MON8714NHatch Joseph B · Mesa, AZN8714PBlanchard Paul R · Florissant, MON8715CDarcy Aviation LLC · Danbury, CTN8715DKline Linda L · Fountain Hills, AZN8715LScott Ts Ag Flyin Inc · Colquitt, GAN8715NKenmore Crew Leasing Inc Trustee · Bellingham, WAN8716MWilliams Excavating Inc · Partlow, VAN8716NWeiss Ariel · Bisbee, AZN8716WIts Just Plane Fun LLC · Gilbert, AZN8717VSepko Joseph M III · Mebane, NCN8717YParker Meyers And Roth Inc · Morgan Hill, CAN8718DSlaughter James M Jr · Houston, TXN8718MGilson David R · New Port Richey, FLN8718NKelly Bradford S · Bedford, NHN8718WB Max Aviation LLC · Mesa, AZN8719FKinzie Wayne · Alva, OKN8719PAndrofski Joseph B · Waunakee, WIN8719VBluemel Steve · Auburntown, TNN871ACAri Ben Aviator Inc · Fort Pierce, FLN871CCUeckert Russell N · Abilene, TXN871CPRedstone Arsenal Flying Activity · Redstone, ALN871DMId Air LLC · Apopka, FLN871FFunk Kevin A · Crescent City, FLN871MAN2634mm LLC · Farmingdale, NYN871PDJohnson Aircraft Leasing LLC · Springfield, ILN8720FWaters Lindsay R · Deland, FLN8720MHulme Aviation LLC · Gilbert, AZN8720NHogan David A · La Crosse, WIN8720PBarry Edward P III · Redlands, CAN8720WKerklo Michael W · Seville, OHN8721NCobe Aviation LLC · Miller, SDN8721PLavergne Rusty P · Denham Springs, LAN8721VEliasquevici Abrao · Ocala, FLN8722CMayhew Oliver C Jr · Blairs, VAN8722DWirthlin Donald K · Sierra Vista, AZN8722NKrueger Sandra J · Chicago, ILN8722PMurphy Josiah I · Jarrettsville, MDN8723COracle Aviation LLC · Omaha, NEN8723ECronk Howard J · Council Bluffs, IAN8723PSima Ronald Scott · Glendale, AZN8723ZKnapp James A Trustee · Casa Grande, AZN8724Fairhope Decathalon LLC · Fairhope, ALN8724DMoe Daniel N · Mukilteo, WAN8724EDcs School Of Flying LLC · York, PAN8724FDel Rio Aviation Inc · Paso Robles, CAN8724MKleiber Timothy D · Independence, KSN8724NSea 2 Sea LLC · Cantonment, FLN8724WFrench Loren C · Gypsum, CO
Back to AD 87-10-06 R1