AD 2017-02-06
Registered aircraft · 201
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:2017-02-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-02-06')
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:2017-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-02-06') 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.
N80MALsc Construction Inc · Perris, CAN818SFSierra Foxtrot LLC · Dodge City, KSN819SWWho Dey LLC · Savannah, GAN81MSCapital Craft LLC · Wilmington, DEN824CBHelfrick Edward W Jr · Elysburg, PAN827LPSagamore Aviation LLC · Lewes, DEN82XLFast Fly Inc · Dallas, TXN83CACheyenne 2 LLC · Colonial Heights, VAN83MGWatkins Jon Trustee · Florence, ORN843DBDoan Creek LLC · Walla Walla, WAN89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYN901TKAviation Trust Company LLC Trustee · Oklahoma City, OKN90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKN90VMJ & B Leasing Inc · Springfield, MON910AGCreative Marketing Associates Inc · Saint Petersburg, FLN910HGTiffin Aire Inc · Tiffin, OHN910JPRegistered aircraftN913NCDeweese Michel J · Rockvale, TNN914ASRed Speakers LLC · Newark, DEN916RTAasjng LLC · Holdrege, NEN917TPAerial LLC · Kalispell, MTN918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKN9202YRomeo Aviation Ltd · Canton, OHN9210YOswald Sean B Trustee · Reno, NVN9212YS & B Foundation Air LLC · Auburn, ALN9224YFavret Bernard A · Ocean Springs, MSN9225YDodson International Parts Inc · Rantoul, KSN9231YBbees LLC · Moss Point, MSN9235YKamasano LLC · Highland, CAN9237YIal Corp · Lewes, DEN9239YDelgado John F · San Antonio, TXN9244YParker Aircraft Sales Inc · Wilmington, DEN9245YMiles Aviation LLC · Sheridan, WYN9262YTwin Star Montana LLC · Kalispell, MTN9266YTiffin Aire Inc · Tiffin, OHN9272YIal Corp · Lewes, DEN937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeN93SHBasin Air LLC · Mattawa, WAFirst renewal noticeN944GMSix States Rentals Inc · Union, MON950CTJack Of Queens LLC · Afton, OKN950SACrop Dusters LLC · Maurice, IAN96MAGoldielochs Air LLC · Annapolis, MDN970PSKrech Greg Trustee · Huron, SDN977GUS Nameplate Co · Mount Vernon, IAN980CATlh Enterprises Inc · Corsicana, TXN982KAircraft Guaranty Corp Trustee · Oklahoma City, OKN98FAHigher Purpose Aviaiton LLC · Spring Lake, MIN98TGBell Scott W · Greeley, CON990LRDavis Aviation Inc · Brandon, MSN998LMArmstrong Airlines Inc · Dover, DE
Back to AD 2017-02-06