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.
N9997PSullivan Michael · Cazenovia, NYN9997TFrazer Scott Cameron · Durango, CON9997VBecker Philip J · Ocean Isle Beach, NCN99981Sky High Leasing Services LLC · Lakeland, FLN9998AWhite Fox LLC · Springdale, ARN9998HBas Part Sales LLC · Greeley, CON9998JBecker Flying Service Inc · Hartington, NEN9998NFoulk William H · Shelburne, VTN9998TTilley Melvin D · Sperry, OKN9998VCox Danny A · Panama City Beach, FLN9998XSells James O · Peachtree City, GAN99991Genovese Mark A · Baltimore, MDN9999BMccole Kevin · Brookline, NHN9999TN9999t LLC · Boulder, CON9999XBogart Sean A · Anchorage, AKN999AFThree Four Juliet LLC · Orange, CAN999AGClark Chase H · Ozona, TXN999ARD R Tripp Enterprises LLC · Omaha, NEN999AVSouza Engineering Contracting Inc · San Luis Obispo, CAN999BMDewitt Stephen R · Port Aransas, TXN999CFPerkins Nathan Zackery · Bonanza, ORN999CGEdling Leon K · Colorado Springs, CON999DGFoghorn Airfleet LLC · Columbus, INN999DKSkt Seaplanes LLC · Huntsville, ALN999HRPage Edward C · Thornhurst, PAN999JJAlpine Holdings LLC · Kalispell, MTN999JTCdm Dirt LLC · Snowflake, AZN999KBBurgess James H · Cora, WYN999KMMaule Aviation LLC · Las Vegas, NVN999KWTeodoro Scott · Fox Island, WAN999LWTroposcatter Inc · Wilmington, DEN999MHDetiger Elizabeth · East Stour DorsetN999PAGoodwin William S · Sequim, WAN999PCFlying T LLC · Albuquerque, NMN999QAQuebec Alpha LLC · Milwaukie, ORN999RDSale Reported · Colorado Springs, COSale reportedN999TKPearson John L · Stevensville, MTN999UCLinville Rex D Trustee · Sarasota, FLN999WBEastern Kentucky University · Richmond, KYN999ZPGassen Paul E · Fallbrook, CAN99ABrown Ashley A · Fort Worth, TXN99BHBarker Aviation LLC · Ardmore, OKN99DDLussier John A · Greene, RIN99DSToutant Roland J · Woodstock, CTN99EAndrews University · Berrien Springs, MIN99EBAir Wings Enterprise LLC · Roca, NEN99FC4th Street Group LLC · Signal Mountain, TNN99FEN99fe Aircraft Services LLC · Lubbock, TXN99GBBright Edgar H · Collegeville, PAN99GFDemon Diversified LLC · Wilmington, DE
Back to AD 87-20-03 R2