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.
N6404UPhiyawa Airplane Holding Inc · Argyle, TXN6404YUphold Thomas R · Arlington, TXN64053Collins Thomas A · Orleans, MAN64056Angel Aviation Inc · Peoria, AZN6405JTubesing Gordon Earl Trustee · Palm Coast, FLN6405PSundstrom Raymond C · Ottawa, KSN6405WNightline Air LLC · Saratoga Springs, UTN64061Stark Glenn M · Nampa, IDN64062M G Enterprises Of Albert Lea Inc · Alden, MNN64063Bowers Alan B · Bellevue, WAN64065Lg Holdings LLC · Gretna, NEN64067Duvall Chris D · Tahlequah, OKN64069Whiskey Tango Aviation LLC · Keene, NDN6406JAntonovich Thomas W · Mesa, AZN6406QHilten Robert W · Columbus, MTN64074Green Norman D · Lake City, FLN64079Portneuf Holdings LLC · Chubbuck, IDN6407DWalo Enterprises LLC · Aurora, CON6407JSleepy Creek Farm - Ga LLC · Gray, GAN6407PSmith Wesley K · Billings, MTN6407RKubisiak Steven F · Amherst, WIN6407VWard Matthew A · Fort Worth, TXN6407WDoeden Patricia · Hillsborough, NCN64081Burrows Donna M Trustee · Grain Valley, MON64082Mcdonald Douglas W Sr · Cornelia, GAN64087California Airways LLC · Hayward, CAN6408ASpecialty Aero LLC · Creswell, ORN6408GWebb Joe R · Union, WAN6408JGish David L · Mooresville, NCN6408UMckee Michael S · Piney Creek, NCN64092Falcon William D · Elkhorn, WIN64095Righthand 2004 LLC · Charlotte, NCN64096Bissey Roy H II Trustee · Big Horn, WYN6409CCrider Richard S · Prescott, AZN6409DMontgomery Aviation LLC · San Diego, CAN6409QButz Kyle W · Swanton, OHN6409RFly 365 Ltd · Montrose, CON6409UJohnson Lynn · San Diego, CAN640BDEdair LLC · Newport, RIN640CPCivil Air Patrol · Maxwell Afb, ALN640DGGeese Douglas A · Churubusco, INN640FTFlorida Institute Of Technology · Melbourne, FLN640GCComanche 640gc LLC · Henderson, NVN640KRCarson Michael W · Oxnard, CAN640MGAviate LLC · Green Bay, WIN640NDUniversity Of North Dakota · Grand Forks, NDN640SAMcm Aircraft LLC · San Antonio, TXN640SPJet Air Inc · Iowa City, IAN640SUThrush Robert L · Bandon, ORN640TCWingsleasing LLC · Wichita, KS
Back to AD 87-10-06 R1