AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N3118SMccormack Nicole E · Greenwood, CAN3118TButts Thomas E · Alma, GAN3118UMaytown Sport Parachute Club · Marietta, PAN3118VKemper Joseph C · Coxs Mills, WVN3118XMoody Dalton T · Evansville, INN3118YTeerlink Craig N Trustee · Cedar Hills, UTN3119FAbsolute Fencing LLC · Granger, WAN3119JBerthelsen Mark A · Baker City, ORN3119RChern Jeffrey · Oakland, CAN3119SFinch Michael J · Springfield, TNN311BC311bc LLC · Channelview, TXN311BTBob Air LLC · Concord, MAN311CASouthern Wings LLC · Shreveport, LAN311CFHronkin Jessie G · Palmer, AKN311EHFive Six Zero One LLC · Orange, CAN311HBChristiansen Aviation LLC · Wilmington, DEN311JBJack Brain And Associates Inc · Castro Valley, CAN311JHHuaco Aviation LLC · Waco, TXN311KMDream Flight Florida LLC · Wellington, FLN311MMAndrews Karen · Napa, CAN311RWWashburn Harrill Gene Jr · Rutherfordton, NCN311SFBaymag Aviation LLC · Mountain Home, ARN311SGRapattoni Ryan · Los Angeles, CAN311SKDoyle Thomas Michael · New City, NYN311TLM & N Enterprises LLC · Topeka, KSN3120FLengyel Roger · Santa Fe, NMN3120QLinda In The Sky LLC · Webster, MNN3120RBulang Investments LLC · Newbury, NHN3121DFrey Jerry P · Fallon, NVN3121FLily Chris H · Ocala, FLN3121THall Tyler · Billings, MTN3122JMulvihill Murphy A · Northbrook, ILN3122STecumseh Skydiving School LLC · Tecumseh, MIN3122YJti Management LLC · Colfax, WAN3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeN3123EKanase Padmaneel B · Amarillo, TXN3123QDarkhorse Six Inc · Boerne, TXN3123RHs Aviation Holdings LLC · Eagle, IDN3123SGabin LLC · Tulsa, OKN3123VColemaker Aero & Marine LLC · Saint Augustine, FLN3123XRegistered aircraftN3123YAbecca Corporation · Jackson, MIN3124DBurch David C · Flushing, MIN3124FTrue Aviators LLC · Kiowa, KSN3124RMidland Liberty LLC · Midland, MIN3125DDavis Ronald L Jr · Soldotna, AKN3125FHall Aircraft LLC · Kenai, AKN3125QSunrise Aviation Llp · Gig Harbor, WAN3125THamilton Brian H · Currie, MNN3125WRowe Benjamin Stratton · Nome, AK
Back to AD 97-01-13