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.
N6611UVan Koevering Dennis Jay · Hudsonville, MIN6611WBryant Bryce Nicholas · Crothersville, INN6612LSwanson Thomas J · Pukwana, SDN6612RCourtney David P · Reedsport, ORN6612UGiem James L · Coupeville, WAN6612VEverman Terry Jay · Vassar, MIN6613H6613 H Ltd · Wilmington, DEN6613RPollazzi Steven N · New Hope, PAN6613WBanks Jeffrey G · Columbus, OHN6613YAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationN6614UVanderford Kenneth W · Fort Worth, TXN6614VThomas Anna D · Kiana, AKN6615DCivil Air Patrol Inc · Montgomery, ALN6615JAeropenn Aviation Academy LLC · Paxinos, PAN6615NTexas Skyways Research & Development · Boerne, TXN6615UDobos Lester J · Bordentown, NJN6615WLoughridge Steven L · Montezuma, OHN66168C P Aviation · Santa Paula, CAN6616DMjng Investment Group LLC · Melbourne, FLN6616HBurke Anthony · Poughkeepsie, NYN6616JBrack Enterprises LLC · Indianapolis, INN6616PMorrison Austin · Statesville, NCN6616RVanover Kevin · Whitesburg, KYN66175Stohlquist James R · Alamosa, CON66177Newman Ken · Hood River, ORN6617ELinstad Daniel Elmer · Canby, ORN6617HNorth Franklin County Flying Club · North Lawrence, NYN6617JJeffries Holdings LLC · Bargersville, INN66184Sec Fl Corp · Santa Rosa Beach, FLN66189Skynick Enterprises Inc · Tarzana, CAN6618DStein Air LLC · New Ringgold, PAN6618PChurchill John C · Parker, AZN6618VLang Gerald K · Baker, MTN6618WLe Ariya · La Crosse, WIN6618ZRotor And Wing · Tioga, NDN6619DBannwart Justin S · North Liberty, INN6619JBjelland Nathan D · Phoenix, AZN6619PRatliff Byron L · Paragould, ARN6619ULucas Jolie Candace · Pismo Beach, CAN6619VTeton Leasing LLC · Pocatello, IDN661ASSaldarriaga Alvaro · Ocala, FLN661CCMarkey John J Jr · Aurora, ILN661DJRadley Larry L · Universal City, TXN661FLS B Enterprise LLC · Marshall, TXN661FTFlorida Institute Of Technology Inc · Melbourne, FLN661HPMotorcarlease USA Inc · Miami Beach, FLN661JCKruse Thomas S · Mena, ARN661JPEvans Craig A · Irvine, CAN661JSStrausbaugh Joseph A · Dublin, OHN661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 87-10-06 R1