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.
N8578CRiver Valley Flyers LLC · West Hartford, CTN8578DCoy Shane A · Nenana, AKN8578PGibbs Gregory Curtis · Engelhard, NCN8578VNelson Timothy E · Fairbanks, AKN8578ZSkyborne Airline Academy Inc · Vero Beach, FLN8579Ralls Eddie · Evergreen, ALN8579CSolberg John W · Bismarck, NDN8579NWillaero LLC · Union City, TNN8579PWor LLC · Jamaica Beach, TXN8579VWalsh Leo A Jr · Anchorage, AKN8579WWessler George H · Dunedin, FLN857AKOld City Helicopter Sales LLC · St Augustine, FLN857DKKnight Kevin · Dallas, TXN857GArcher Flight LLC · Wilmington, DEN857JWWarren Joseph A · Milford, DEN857MMVigilante Helicopters LLC · Lewistown, MTN857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeN857RDUniversity Of North Dakota · Grand Forks, NDN857SSjs Aviation Co · Casper, WYN857SCFf22 LLC · Scottsdale, AZN857SPSoutheastern Oklahoma State University · Durant, OKN857WAAircraft Guaranty Corp Trustee · Oklahoma City, OKN8580DKedrowski James L · Wasilla, AKN8580ESkyborne Airline Academy Inc · Vero Beach, FLN8580NA1 Aviation LLC · Lewis, DEN8581ASkyborne Airline Academy Inc · Vero Beach, FLN8581DDutch Air LLC · Kalispell, MTN8581JSkyborne Airline Academy Inc · Vero Beach, FLN8581VObx Airplanes LLC · Manteo, NCN8582CCurran Aviation Services LLC · Yorba Linda, CAN8582ESkyborne Airline Academy Inc · Vero Beach, FLN8582JMarchione Laverne R · Diamondville, WYN8582PSchwalbach Russell R · Bondurant, IAN8583BSkyborne Airline Academy Inc · Vero Beach, FLN8583PLl Aviation LLC · Kansas City, MON8583VMorten John E DBA · Larimore, NDN8583YGray Michael W · Cheyenne, WYN8584DSkyborne Airline Academy Inc · Vero Beach, FLN8584PHackens Donald G · New Underwood, SDN8584WSawyer Clissie M · North Platte, NEN8585DMadsen Travis E · New Underwood, SDN8585HSkyborne Airline Academy Inc · Vero Beach, FLN8585PNelson Christopher A · Silver Spring, MDN8585YGospel Ministeries International Inc · Mc Donald, TNN8586JSkyborne Airline Academy Inc · Vero Beach, FLN8586YTrue Glenn C Jr · Phoenix, AZN8587BDorsey Tony A · Anchorage, AKN8587DSouthard Bryan O · Moneta, VAN8587LSkyborne Airline Academy Inc · Vero Beach, FLN8587TJet Winds LLC · Gulf Shores, AL
Back to AD 87-10-06 R1