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.
N2716XShaw Brandon L · Juneau, AKN2717GKlotz Terrance M · Sparks, NVN2717SMartin Tyler · Pompano Beach, FLN2717URasmussen Raleigh C · Seattle, WAN2718FJackalope Flyers LLC · Whitefish, MTN2718QJenerette Marcus · Galivants Ferry, SCN2718SBurroughs David G · El Paso, ILN2718UBondurant Ross · Eugene, ORN2718XPoirier Theodore N · Biddeford, MEN2718YRichland Aviation Inc · Sidney, MTN2719FSjoblom Erik Anders · Washington Twp, MIN2719JDewey Robert P · Ramona, CAN2719UVilches Armando L · Brentwood, TNN271AMMonthy Christian · Van Nuys, CAN271DTuckerman Kurt W · Branford, FLN271GTBroulik Robert L · Lisbon, IAN271REEigsti Rodney E Trustee · Friend, NEN271RGCapitol City Flyers Inc · Madison, WIN271RMMartinson Ryan D · Nome, AKN2720EAmerican Patrols Inc · Midland, TXN2720GGenstler Jeremy A · Apple Valley, CAN2720LBaalman Gary E · San Jose, CAN2720QDelta Yankee Aviation LLC · Anguilla, MSN2720XStubbs John C · Bangor, MEN2721JDe Aviation Inc · La Porte, TXN2721QN2721q LLC · Stuart, FLN2721SPeyton Investments LLC · Washington, NCN2722GEpperson David C · Salt Lake City, UTFirst renewal noticeN2722LSmolik Amanda · Northlake, TXN2722XRearden Michael B · Homer, AKN2723EMarshals Technology LLC · Martinez, GAN2723FTrantham Robert Keith · Alexandria, ALN2723GReno Timothy J · University Place, WAN2723LJkr7 LLC · The Dalles, ORN2724FIsley Rocky · Lacey, WAN2724JHorseshoe Air LLC · Pella, IAN2724UGarner Harry W · Le Roy, NYN2724XParrott Charles F · Bridgton, MEN2725F85 Charlie Papa LLC · Phoenix, AZN2725JQuinn Timothy · Bountiful, UTN2725LFulenchek Raymond D · Sherman, TXN2726FMid America Sprayers Inc · Ulysses, KSN2726GFarmhouse Aerospace LLC · Laurel, MTN2726USampan Aviation LLC · Greenville, TXN2726VTurpin Michael · Rcho Sta Marg, CAN2727LAircraft Trustee Services Inc Trustee · Dover, DEN2727QEstes Gregory T · Jonesville, VAN2727SMiller Colin B · Fargo, NDN2727URoy Justin C · Georgetown, OHN2727VFitzgerald Kevin C · College Station, TX
Back to AD 97-01-13