AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N9987NUnited States Department Of Interior · Boise, IDN9987VKaplan Steven M · North Monmouth, MEN99881Civil Air Patrol · Maxwell Afb, ALN99885Az2025 LLC · Miami, FLN9988NBackcountry Air LLC · Wilmington, DEN9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeN9988XBenavides Antonio · Anchorage, AKN9989AHatcher Bradley M · Jackson, GAN9989ET Craft Aero Club Inc · Nampa, IDN9989TGreat Basin Aviation LLC · Eagle River, AKN9989VPace Dusty · Pendleton, ORN998MSteamboat Springs Flying Club Inc · Steamboat Springs, CON998RASchubert Brothers Aviation Inc · Canandaigua, NYN998SEUtter Albert · Fort Myers, FLN9990BAurora-Flight LLC · Commerce Township, MIN9990EN9990e LLC · Alva, FLN9990VCompass Aviation Inc · Shelby, NCN99917Anderson Cody Jon · Orono, MEN9991ASaunders James E · La Vista, NEN9991BTaft Leasing LLC · Bloomfield, NMN9991EWings Flight Enterprises Inc · Danville, KYN9991GSale Reported · Staten Island, NYSale reported, canceledN9991NTin Cup Aviation LLC · Frostproof, FLN9991TChupp Family Trust LLC · Kalispell, MTN9991VSafeway Flying Club Inc · Denmark, WIN9991YArwlb Aviation LLC · Spokane, WAN9992BAirco International LLC · Arlington, WAN9992EWoods Charles D · Huffman, TXN9992GDaneker Adin · Kalispell, MTN9992NHanson Lavon T · Saint Ignatius, MTN9992VShipe Jacqueline M · Louisville, TNN9992ZAdvanced Placement Aviation LLC · Eagle River, AKN9993BTurinsky Anthony · Anchorage, AKN9993ECruise Flight Academy Inc · Dalton, GAN9993THusbands Jason · Belen, NMN99948Florida State College At Jacksonville · Jacksonville, FLN9994EBeard Michael W · Eveleth, MNN9994HCasey James D · Burlington, MAN9994NBoynton Scott · Campbell Hall, NYN9994VWings Over Texas Holdings LLC · Denton, TXN9995BAlbatross Air Inc · Mccall, IDN9995EWilliams Dean W · Punta Gorda, FLN9995NIrvine Hollis E Jr · Greenwich, NJN9996EMeier Sally A · Lac Du Flambeau, WIN9996HStrong Jennifer E Trustee · Lakeport, CAN9996JDiamond X LLC · Elko, NVN9996MYr-Aircraft Leasing LLC · Bethel, AKN9996NMorrison Otto M · Harrisburg, ARFirst renewal noticeN9997EAir Data Solutions LLC · Natchitoches, LAN9997FUsda Forest Service Fepp · Columbia, SC
Back to AD 87-20-03 R2