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.
N9958TKonefal Arthur J · Fairbanks, AKN99598Registration Pending · Argyle, TXRegistration pendingN9959ANelson Jayson A Trustee · Caldwell, IDN9959BHackamore Equipment LLC · Prairie City, SDN9959ETyler Matthew S · Lakeside, CAN9959HThibault William N · Newport Beach, CAN9959RRusyniak Anthony J · Syracuse, NYN9959XMiller Keith D · Pittsburgh, PAN9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeN995JAN995ja LLC · Ft Lauderdale, FLN995NABucher Devin V · Kalispell, MTN995SBRossi Randall A · Georgetown, TXN995VZMeyerowitz Noah A · Great Barrington, MAN99606Civil Air Patrol Inc · Maxwell Afb, ALN9960BSouthern Aircraft Leasing LLC · Montgomery, ALN9960EArklamiss Aviation LLC · Ruston, LAN9960NBoemer Steven E · El Cajon, CAN9960RInternational Air Services Inc Trustee · Carson City, NVN9961ERuryk Jonathan D · Pineville, LAN9961VCk Leasing Services LLC · Wilmington, DEN9962ESynergy Financial Services Inc · Vancouver, WAN9962MFox Aircraft LLC · Bethel, AKN9962TWh72 LLC · Lincoln, NEN9963EDenski David T · Plymouth, MIN9963NWoodward Aviation LLC · Alpine, TXN9963YN9963y LLC · Provo, UTN9964CTakle Management LLC · Bethany, OKN9964EJansen Christopher · Stilwell, KSN9964HBuchanan Gary · Jay, FLFirst renewal noticeN9964LHess Garrett J · Fullerton, CAN9964YGreenspun Mark H · Washington, DCN9965ARobertson Francis E · Hibbing, MNN9965BTuma Tom · Cut Bank, MTN9965XNistler Matt J · Three Forks, MTN9966BKimbrell Heath · Quinlan, TXN9966NBeeson John Charles · Palmer, AKN9966TItalio River Adventures LLC · Yakutat, AKN9966VLeisner David L · Palmer, AKN9966XFickus Timothy R · North Pole, AKN9967CJoemac Business Services LLC · Casper, WYN9967NSawtooth Aviation LLC · Hovland, MNN9967RBravan Aviation · Fort Lauderdale, FLN9968APickett Steven M · Odenville, ALN9968CPaulin Gregory H · Flagstaff, AZN9968EReeder Joseph · Northfield, MNN9968GPetecraft Aviation Services Inc · Plains, GAN9968JBoening Bros Dusting & Spraying Scv · Floresville, TXN9968LMw Flying LLC · Sanford, NCN9968NBuhannic Patrick A · Shepherdstown, WVN9968TMontague Robert · Kilmichael, MS
Back to AD 87-20-03 R2