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.
N9400EVan Anda Aviation LLC · Apopka, FLN9400HRoach John C · Lawrenceburg, KYN9400JRobinson William L · Buckeye, AZN9400KSyvanen Janne M · Staten Island, NYN9400LMerino Cesar · Washington, DCN9400PKoretsky Aviation LLC · Fairless Hills, PAN9400WLow Wing Aviation LLC · Mountain Home, ARN9401CRegistered aircraftN9401DBenesh Stephen P · Oshkosh, WIN9401HConstantine Costas T · Newington, CTN9401LAustin Aviators Flight Club · Austin, TXN9401NJanes Charles Dale · Cleburne, TXN9401PGranite Aviation LLC · Belgrade, MTN9402JHigh Flight Flying Club LLC · Reston, VAN9402KCash Management Consulting LLC · Granite Springs, NYN9402PSteinberg Franklyn C III · Flemington, NJN9403DKlingenberg Tim C · Udall, KSN9403VSwift Damian · Livermore, CAN9404FBas Part Sales LLC · Greeley, CON9404HSowell Richard G · San Jose, CAN9404JCordice Jearohan Giles · Fort Worth, TXN9404KJmy Aviation LLC · Merritt Island, FLN9404N9404n LLC · Brush Prairie, WAN9405JSky Blue Horizon Aviation LLC · Gainesville, GAN9405PDoyle Kevin M · Kenai, AKN9405VShoop Robert A Jr · Austin, TXN9406DMartin James D Sr · Coeur D Alene, IDN9406JNorth County Flight Training Inc · Carlsbad, CAN9406PHager Jerome P Jr · Frazee, MNN9406VKuyami Inc · Las Vegas, NVN9407DMatthew P R Mcdaniel · Oak Creek, WIN9407HB2w Corporation · Winona, MNN9407KCollebrusco Robert L · Springfield, ILN9407PHoefle Aviation Inc · Wilmington, DEN9407VWarkentin Lynden K · Russell Springs, KYN9407WLozes Jay P · Covington, LAN9408LMccallum David DBA · Napa, CAN9408NCope Parrish B · Lemoore, CAN9409CN9409c LLC · Phillipsburg, KSN9409LLaguna Verde Leasing Inc · Wilmington, DEN9409PDormond Brent C · Glendale, CAN9409WMoffett Richard · North Las Vegas, NVN940AMOracle Aviation LLC · Omaha, NEN940DLeighton George E · Seattle, WAN940FSYogini Modi · Homestead, FLN940MAMoore Charles H · Richmond, TXN940SMCrosby Seth J · Anchorage, AKN940SSKnoll Forrest D · Schaller, IAN940TCMusser John R · Freeport, ILN940TESimmerman John Jr · Harrisburg, NC
Back to AD 87-10-06 R1