AD 2023-17-13
Registered aircraft · 1,956
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:2023-17-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:2023-17-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:2023-17-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:2023-17-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.
N116CHEchols Randall J · North Pole, AKN116PFPacific Flight Academy LLC · Honolulu, HIN116VASky High Aviation LLC · Arkadelphia, ARN11855Jones Steven A · Stafford, VAN118JWWheaton Jonathan B · Alexander, MEN119AMLight Sport Works LLC · Deland, FLN119RSSmith Ronald L · Lucedale, MSN119VAOne One Niner LLC · Houston, TXN11HLAv8me LLC · Spicewood, TXN11SKStemme N11sk LLC · Missoula, MTN1204KDrewry Jeremy W · Centerburg, OHN120BASouth Coast Marine LLC · San Diego, CAN120STStemme USA Inc · West Columbia, SCN120TLHarrison Richard R · Sacramento, CAN1213HBoyle Steven J · Largo, FLN121EARegistered aircraftN121FRWisconsin Fox River Flyers Inc · Milwaukee, WIN121FUMalir Richard E · Powell, OHN121NWGraylynn Aviation LLC · King, NCN121SFSky Jack LLC · Nicholasville, KYN121WHQualitair LLC Trustee · MichelstadtN1227ZFisichella David C · Falmouth, MAN122BGill Kevin W · Massillon, OHN122CZChaz Air Cam LLC · Wellington, FLN122KAAviate LLC · Hazelton, IDN122ZBRistow Kurt · Seneca, SCN12301Guttman Antonin · Santa Cruz, CAN1232AAviation Financial Corp · Torrance, CAN123JGMullins Steve D · Springfield, MON123RRCampana Thomas J · West Palm Beach, FLN123TNMontana Retirement Center LLC · Kalispell, MTN123WHCox James Lee · Danville, ILN123YZFleisher Paul · Santa Monica, CAFirst renewal noticeN1248Johnstone Terry D · Scottsdale, AZN124AFinck Charles F · Liberty Lake, WAN124FAFirst Airborne LLC · Cocoa, FLN124TKRegistered aircraftN124VAChi Aerospace Inc · Portsmouth, NHN124WLarson Bruce W · Urbana, OHN1252SFlying Felix One LLC · Chicago, ILN126ZXStockwell Robert L · New Harmony, UTN128BAIcon Aircraft Inc · Vacaville, CAN128BMEpic Aviation Inc · Denison, TXN128CJGray Jason F · Nampa, IDN128DGCharles O Moore Sport Pilot LLC · Bluffton, SCN128MFAircraft Guaranty Corp Trustee · Oklahoma City, OKN128RVD&R Sky Venture LLC · Springfield, MON129DCMoonbeam Management LLC · Longwood, FLN129GFFrick Gary A Trustee · Marion, INN129RRSteadfast Entities LLC · Philadelphia, PA
Back to AD 2023-17-13