OpenAirDocs.org
AD 75-23-08 R5

Registered aircraft · 999

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:75-23-08-R5')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5')
  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.

N543PMPhillips Brant · Franktown, COS/N 421C0280N5443JKg&C Investment LLC · Saint Charles, ILBuilt 1975 · S/N 421B0901N5448JInfinity Aviators LLC · Scottsdale, AZBuilt 1975 · S/N 421B0906N5478GOn Wings Of Eagles LLC · Valley Center, CABuilt 1976 · S/N 421C0225N5484JCaba Joseph · Covington, LAS/N 310R0282N5497GRichardson Farms Land Mgt Inc · Pittsfield, ILS/N 421C0244N54CRCage Presnall C · Falfurrias, TXS/N 421C0812N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621N558BFMatrix Aviation LLC · Birmingham, MIS/N 421C0845N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713N56RXKing Cobra Investments LLC · Rancho Cordova, CABuilt 1976 · S/N 421C0207N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042N5752MColeman William J · Redondo Beach, CABuilt 1968 · S/N 310P0052N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065N5770MBallard Aviation Inc · Newton, KSBuilt 1968 · S/N 310P0070N577KGMccloy Mark T · Tatum, NMS/N 421C0906N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451N5800MRidgewood Associates Inc · Nevada City, CAS/N 310P0100N581CJDodson International Parts Inc · Rantoul, KSS/N 421B0343N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125N583DWKinetic Systems Inc · Richmond Hill, GABuilt 1973 · S/N 421B0583N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143N587GFReher David P · Arlington, TXBuilt 1975 · S/N 310R0246N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N5889MKinney James R · Vermillion, SDBuilt 1969 · S/N 310P0189N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N593DMLister John · Pipe Creek, TXS/N 402B1228N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870N5NNRkgrier LLC · Beckley, WVS/N 421C0446
Back to AD 75-23-08 R5