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.
N9932ZSilver Creek Aviation Services · Fort Worth, TXN99338Civil Air Patrol Inc · Maxwell Afb, ALN9933ATravelair Inc · Ocala, FLN9933BHenkemeyer Joseph S · Cave Creek, AZN9933MAlaska Aircraft Leasing LLC · Silverdale, WAN9933TOrr Kory A · Hay Springs, NEN9933ZFreelance Air · Kennesaw, GAN99341Jlinn Aviation Inc · Quinlan, TXN99344Global Tours & Travel Services LLC · Davie, FLN99347Skywarrior Flight Training Inc · Pensacola, FLN9934BMasterson Kevin M · Eagle River, AKN9934EStenger D James Trustee · Sonora, CAN9934GDiorio Christopher J · Melba, IDN9934NAtkins Ricky K · Placerville, CAN9934QDoupe Services LLC · Fort Myers, FLN9934VRuby Aviation LLC · Oak Creek, CON9934XLogue James · Fort Worth, TXN9934ZParagon Air Group · Fort Worth, TXN9935AMichael Monte E · Axtell, TXN9935BCarpenter Willard D · Borrego Springs, CAN9935ERegistration Pending · Belington, WVRegistration pendingN9935HKahn Lawrence · Upper Lake, CAN9935MFreshwater Adventures Inc · Dillingham, AKN9935NMeggers Roger D · Baker, MTN9935RUsda Aphis Ppq · Edinburg, TXN9935VD & S Aviation LLC · Wilmington, DEN9936QHunt Richard M · Columbus, OHN9936VLeading Edge Flight Academy LLC · Bend, ORN99377Barta Terry · Faribault, MNN9937AInternational Air Services Inc Trustee · Carson City, NVN9937E7 And 7 LLC · Leon, IAN9937QFosmo Richard E · Eatonville, WAN9938NJohnson Scott A · Missoula, MTN9938TShope Brandon M · North Pole, AKFirst renewal noticeN9938ZSilver Creek Aviation Services · Fort Worth, TXN99396Flightline Air Service LLC · Pineville, LAN9939HVawter Russell R Trustee · Nampa, IDN9939NSylvester Sean W · North Pole, AKN9939VJackson Walter E · Wasilla, AKN9939XGrant Matthew D · Alvord, TXN9939ZRiver Front Akn LLC · Anchorage, AKN993DWDeadstick Holdings LLC · Laguna Niguel, CAN993GAUtopia Flyers LLC · Utopia, TXN993KTFirst Air Service LLC · Show Low, AZN993PPCc Bar Ranch LLC · Texarkana, TXN993SRThree S Ranch Inc · Blanca, CON9940ESaint Louis University · Saint Louis, MON9940MSofinme LLC · Missoula, MTN9940VSoco Aero Leasing LLC · Santa Rosa, CAN9941BBrinkley Christian D · Minneapolis, MN
Back to AD 87-20-03 R2