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.
N9552VRico Aviation Services Inc · Miami, FLN9553ATitusville Aero Club Inc · Titusville, PAN9553JStanley James C · Farmington, NMN9553MLolob Llp · Bozeman, MTN9553SHunters Adventures LLC · Kennesaw, GAN9553WRich Harold W · Fort Worth, TXN9554DChase 13 LLC · Wilmington, DEN9554LWilson Tyler · Blooming Prairie, MNN9554MJohnson Kevin L · Bowling Green, KYN9554TOceanic Airlines LLC · Portsmouth, NHN9554VCavu LLC · Fort Collins, CON9555CVimana LLC · Chandler, AZN9555DGehring Robert A · Rubicon, WIN9555HWilkinson William · Anchorage, AKN9555JPaper Airplane Club LLC · Hillsdale, MIN9555KHiggins Donald Aubrey Sr · Cornelia, GAN9555LSouth Co Flyers Inc · Cranston, RIN9555MCarroll Brendan O · Aloha, ORN9556DHanderson Ronald J Sr · Sitka, AKN9556MVictory Lane Aviation LLC · Concord, NCN9556VMiles James D · Memphis, TNN9556WMathison John M · Fernley, NVN9557BGibson Robert B · Los Alamos, NMN9557KCook Walter T · Centerville, TNN9557LFarrar Curtis L · Pryor, OKN9557VSkyhawk 57v Inc · Pittsburgh, PAN9557WBowles Dan S · Wichita, KSN95583Reynolds Darryl G · Wills Point, TXN9558DMadison James Edward · Concord, CAN9558PStevens Raymond W · Norfolk, VAN95594Sale Reported · Smyrna, GASale reported, pending cancellationN9559DChristiansen Aviation LLC · Wilmington, DEN9559FGeco Inc · Wilmington, DEN9559MPerez Hector R · Orange Park, FLN9559SElizabeth Dloda LLC · Hilton Head Island, SCN9559VOcm Aviation LLC · Buckeye, AZN9559WRickman Kevin A · Brownville, NYN955BJFulfer Richard S · Applegate, CAN955CCN955cc LLC · Estero, FLN955CTTennis Caleb J · San Mateo, CAN955DDRegistration Pending · Fort Wayne, INRegistration pendingN955DGSuperior Aero & Marine LLC · Bolivar, MON955DQWeber Charles · Dubuque, IAN955JPHassan Sibte · Brooklyn, NYN955LCSewell Michael D DBA · Russellville, ALN955MATaylor Christopher B · Vacaville, CAN955PTCappe Investment Group LLC · Homestead, FLN955SEmge Douglas W · Albertville, ALN955SCAb Prop Plane I LLC · Metairie, LAN955SHInternational Air Services Inc Trustee · Carson City, NV
Back to AD 87-10-06 R1