AD 2002-23-13
Registered aircraft · 3,462
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:2002-23-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
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:2002-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13') 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.
N920TTBank Of Utah Trustee · Salt Lake City, UTN921BSOld Dominion Aviation LLC · Statesville, NCN921FEFederal Express Corporation · Memphis, TNN921MFPuerto Coral Corp · Wilmington, DEN921RAAviation Trust Co LLC Trustee · Oklahoma City, OKN922JCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN923FEFederal Express Corporation · Memphis, TNN923JKMs Avation LLC · Waukesha, WIN923LHGrowers Air Service Inc · Woodland, CAN92409Piper Aircraft Inc · Vero Beach, FLN924ACDena'Ina Air Taxi LLC · Anchorage, AKN925ARRnjs Products LLC · Lewes, DEN925DWSundy Aviation LLC · Palo Alto, CAN925FEFederal Express Corporation · Memphis, TNN925KHS660-131dc LLC · Keller, TXN925TKSouthwest Aviation Specialties LLC · Tulsa, OKN926FEFederal Express Corporation · Memphis, TNN926LADevil Dusters Inc · Artesia, NMN927FEFederal Express Corporation · Memphis, TNN927JPBair Aviation Inc · Lake City, SDN927JTPikes Peak Flyers Llp · Colorado Springs, CON92858Blue Aircraft LLC · Ketchikan, AKN928FEFederal Express Corporation · Memphis, TNN928GP402wd Holdings LLC · Robstown, TXN928KAction Offshore LLC · Port Arthur, TXN928KLKa-B200 LLC · San Angelo, TXN928MCLee County Mosquito Control District · Lehigh Acres, FLN928PBMaranatha Leasing & Consulting Inc · Marco Island, FLN928SBBoutique Air Inc · Dallas, TXN928TNBoettcher Aerial Company Inc · Beloit, KSN928WLJobe Industries LLC · Santa Teresa, NMN9295Bank Of Utah Trustee · Salt Lake City, UTN929BWSkyway K LLC · Middletown, DEN929FDFaust Distributing Co Inc · Houston, TXN929FEFederal Express Corp · Memphis, TNN929KTRustair Inc · Anchorage, AKN929PInternational Air Services Inc Trustee · Carson City, NVN92BDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN92CLAircraft Structures International Corp · Enid, OKN92FEWarren Transportation LLC · Dallas, TXN92JASouther Field Aviation Inc · Americus, GAN92JJPa1 208b-1074 LLC · Fort Lauderdale, FLN92KMJohnson Airspray Inc · Argyle, MNN92RKSnk Real Property Holdings LLC · Meta, MON92WEInce Aviation LLC · Dover, DEN9304FSkydive Baltimore LLC · Lincoln, DEN930CFHynes Kevin P · Wichita Falls, TXN930DSAc Aircraft Holdings LLC · Dallas, TXN930FEFederal Express Corporation · Memphis, TNN930HMForgenie Alan Peter · Willsboro, NY
Back to AD 2002-23-13