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.
N9442Winger Aviation LLC · Palatine, ILN94429Wisconsin Aviation Inc · Watertown, WIN9442RPauly Jeff D · Watkins, MNN9443CRvest Management LLC · Boulder City, NVN9443HAllport Bruce E · North Hollywood, CAN9443LTdz Aircraft Holdings LLC · Dover, DEN94447Flightime LLC · Stuyvesant, NYN9444BWallitner Aviation Inc · Renton, WAN9444HPrestige Worldwide Aerospace LLC · Panama City, FLN9444MTriple Four Mike LLC · Sand Springs, OKN9444UB2w Corporation · Winona, MNN9445CSchaller Lee W · New Athens, ILN9445DTriple Fes LLC · San Antonio, TXN9445HBrown Max K · Cushing, OKN9445MSky Masters Aviation Inc · Laguna Hills, CAN9445THale Tom · Browns Valley, CAN9446CAlaskan Luxury Cruises LLC · Willow, AKN9446GStringfellow Regan M · Boerne, TXN9446NSkywagon LLC · Goochland, VAN9446UTepper Jesse J · New York, NYN9447HLang Julia A · Greensburg, PAN9447LAirplane And Drone Flight Instruction LLC · Orlando, FLN9447MWings Aircraft LLC · New Richmond, WIN9447XKaminski Thomas E · Green Bay, WIN9448CAero Marine Inc · Westland, MIN9448MSoto Eduard D Trustee · Somers, MTN9448UValley View Farming Inc · Halsey, ORFirst renewal noticeN9449BLeaders Bob O · Clear Lake, MNN9449XBelk Pritchard Properties LLC · Broken Arrow, OKN944CBCalifornia Baptist University · Riverside, CAN944DHSouth Delta Aviation Inc · West Helena, ARN944JHHiggins James R · Camargo, ILN944PMGasper Air Spray Inc · Crookston, MNFirst renewal noticeN944RRancifer Rodney M · Lithonia, GAN944WBSchultz Jason G · Crowley, LAN94500Training Planes LLC · Tampa, FLN94505Riverside Flight Center Inc · Tulsa, OKN9450DSharabi Avinoam · Las Vegas, NVN9450EAivcon Inc · Charlevoix, MIN9450XDavila R · Runge, TXN94513Hampden Aviation Services Inc · Northampton, MAN9451MSnow Jeffrey J · Mechanicsburg, PAN9451UPilot Pros Inc · Miami, FLN9451XRegistered aircraftN94527Kamer Joseph P · Topeka, KSN94528Daedalus Flight School Inc · P. FokaiaN94529Clary Daryl · Moorestown, NJN9452EDew Jason L · Krum, TXN9452GStokes Letta J · Chugiak, AKN9452HFreeland Thomas W · Early, TX
Back to AD 87-20-03 R2