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.
N284SBWestwind Inc · Liberal, KSN28BGKapowsin Air Sports Ltd · Shelton, WAFirst renewal noticeN294ZPCumulus Aviation Inc Trustee · Wilmington, DEN300SRLevenson Louis · Atlanta, GAN300WPPcp Aviation LLC · Miramar Beach, FLN302TAMidwest Flying Service LLC · Wilmington, DEN303TSCheyenne Air LLC · Ocean City, NJN30DUHtf Aviation LLC · Kalispell, MTN321FUTms Turboprop 2xl LLC · Wilmington, DEN321LBSpeer Transport LLC · El Cajon, CAN324ARParrish Blake · Seminole, TXN328RED & R Ezzell Inc · Rockwall, TXN329KKBristol Aircraft Leasing LLC · Montgomery, ALN331NCRise Aircraft 1 LLC · Tomball, TXN333XXArnot Robert · Stowe, VTN336PN336p LLC · Williamstown, NJN34HM71wg LLC · Tulsa, OKN37PJDodson International Parts Inc · Rantoul, KSN38TWPlanemarketing LLC · Vero Beach, FLN390JDSevern Aeronautics Ltd · Annapolis, MDN390JPLucky7 Air LLC · Lenoir, NCN396JHGoode Todd · Nampa, IDN398SPHillcrest Aviation LLC · Clear Lake, IAN39EHAir Travel Management Of Delaware LLC · Wilmington, DEN39TLDunamis Resources LLC · Lewes, DEN3RKCorinthian LLC · Southgate, MIN400CMAerial Surveys International LLC · Watkins, CON400WSHatbright Farm LLC · Wilmington, DEN401VAPro Aire Cargo & Consulting Inc · Oshkosh, WIN403MCorporate Aircraft Group LLC · Annapolis, MDN406RSAero South Florida Inc · Deerfield Beach, FLN40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNN410CAJustifications LLC · Wilmington, DEN4157EBel Air LLC · Henderson, KYN427DDYunus Asim · Saginaw, MIN427TAAircraft Properties LLC · Hampstead, NCN43WHLaurel Malibu LLC · Windber, PAN444PCValiair Limited Company Trustee · Casper, WYN444RCTiffin Aire Inc · Tiffin, OHN444WGSchmucker Real Estate Holdings Lp · Wilmington, DEN454CACul8tr LLC · Boynton Beach, FLN455MMMiklus Enterprises LLC · Middletown, DEN473GGTiffin Aire Inc · Tiffin, OHN47JFReeve Howard E · Minot, NDN481SWFour Hills LLC - Piper Series · Plano, TXN4938SAviation Trust Co LLC Trustee · Oklahoma City, OKN497WWWin Win Aviation Inc · Wake Forest, NCN50RNOn Three Angels Wings LLC · Melbourne, FLN511PJNanavati Parashar Jayendra Trustee · Springfield, ILN515GAFramalin Leonard · Troy, MI
Back to AD 2017-02-06