AD 2002-22-17
Registered aircraft · 1,016
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:2002-22-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-17')
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:2002-22-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-17') 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.
N509JETwo Percent Aviation LLC · Lewes, DEN511EXCannery Leasing Ltd · Friday Harbor, WAN512DHPlane6 LLC · Fort Lauderdale, FLN512EXTextron Aviation Inc · Wichita, KSN515JMSmith Peter I Trustee · Ocala, FLN515MVJb Aircraft LLC · Anchorage, AKN515PEDog Is My Copilot Inc · Jackson, WYN515PPDog Is My Copilot Inc · Jackson, WYN516NCCobra Aviation Services LLC · Oklahoma City, OKN516PRDepartment Of Natural & Environmental Resources · San Juan, PRN518JJ518jj LLC · Winter Garden, FLN51942Textron Aviation Inc · Wichita, KSN522SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN526LMBentley Raymond · Elverson, PAN527TXTextron Aviation Inc · Wichita, KSN529AB95west Aerial Mapping LLC · Grand Forks, NDN52TEThumb Aviation LLC · Bad Axe, MIN535SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN5366XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN539SATvpx Aircraft Solution Inc Trustee · North Salt Lake, UTN53TEThumb Aviation LLC · Bad Axe, MIN53UPhenphilo3 LLC · Wilmington, DEN543TCWonderful Orchards LLC · Shafter, CAN5453XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN545GCSeattle Aircraft Rentals LLC · Bellevue, WAN549PNSouthern Airways Pacific LLC · Addison, TXN54CUN54cu Inc Trustee · Wilmington, DEN550LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN5512BAircraft Structures International Corp · Enid, OKN555DGBonnie Aero LLC · Dryden, MIN555JCDelaware Aircraft Trust LLC Trustee · New Castle, DEN558EX7s Air LLC · Temple, TXN559BERegistered aircraftN559TSShoe Air LLC · Eagle, IDN569LGPacific Gas And Electric Company · Concord, CAN571DWTextron Aviation Inc · Wichita, KSN571SCGospel Ministries International Inc · Mc Donald, TNN573BABering Air Inc · Nome, AKN575JDArctic One LLC · Fairbanks, AKN575RRemme Kaare · San Marcos, TXN576SATvpx Aircraft Solution Inc Trustee · North Salt Lake, UTN578GCKamaka Air LLC · Honolulu, HIN580EXCessna Caravan Adventures LLC · Miami, FLN583JHBrykin Leasing Corp · Celina, TXN58501Pinellas County Sheriffs Office · Largo, FLN585SASpirit Air Inc · Salmon, IDN5871Sparrow Group LLC · Belton, TXN588PSTaylor 483 LLC · Albuquerque, NMN592SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN593EXMarana Tactical Flight LLC · Tucson, AZ
Back to AD 2002-22-17