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.
N83PAHill Enterprise Inc · Wilmington, DEN83PHValiair Limited Co Trustee · Casper, WYN83PSBurt Donald H · Mason, MIN83PYDecino Robert D · Fritz Creek, AKN83RAPessoa Guiherme · Winter Garden, FLN83RLPowers Jerry · Moriarty, NMN83RQBlais Michel · Jackson, TNN83SMMain Aviation LLC · Naches, WAN83SWRogers Gary A · Novi, MIN83THLrs Dynamics Corp · Port Orange, FLN83TTL1 Air LLC · Wilmington, DEN83TXPike Alan D · South Portland, MEN83VCDoke Ken L · Winton, CAN83VVMccaul Benjamin · San Luis Obispo, CAN83WCRegistered aircraftN83WJSikes Randell D · Dandridge, TNN83ZCrittenden William F · Spokane Valley, WAN84001Darcy Aviation LLC · Danbury, CTN84007Smith Michael W · Sharon, CTN84008Harkey Wesley · Sherrills Ford, NCN84009Swenson Catherine A Trustee · Meadow Vista, CAN8400F337 Skymaster Inc · Miami, FLN8400LInstant Print Signs & Designs LLC · Kalispell, MTN8400SParks Perry A · Goodell, IAN84014C-140 Company LLC · Milton, FLN84015Tarakji Mohamad Hani A · Van Nuys, CAN84019Snodgrass William D · Moberly, MOFirst renewal noticeN8401BSale Reported · Crofton, KYSale reportedN8401DDarwin D Pluid · Eureka, MTN8401FSchriner Keith D · Lanark, ILN8401LBlack Baron Air LLC · Kalispell, MTN8401RLaplante David W · New Baltimore, MIN8401SRg Aviation LLC · Fulton, MSN8401TWingsleasing LLC · Wichita, KSN8401VGlenn Larry W · Bunn, NCN84023Sidoti Charles A · Boston, MAN84024Maurano Michael R · Long Island, VAN84026Smith William A Jr · Tulsa, OKN8402BMays Richard N · Lakeway, TXN8402CConner W Larry · Los Lunas, NMN8402LVan Bortel Inc · Victor, NYN8402RLivengood Leasing Co LLC · Mesa, AZN8402SHigh Noon Leasing LLC · Anchorage, AKN8402WAnderson Thomas · La Quinta, CAN84036Wings Over Texas Holdings LLC · Denton, TXN8403BVolare Via LLC · Piqua, OHN8403DTelford Aircraft LLC · Telford, TNN8403LAarow Aircraft Leasing LLC · Mcminnville, ORN8403PNewell Douglas Bryon · Sedalia, MON8403RSenmounnarath Sam · Murfreesboro, TN
Back to AD 87-10-06 R1