AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-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:2005-10-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:2005-10-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:2005-10-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.
N7062XPatriot Aviation Inc · Greenville, DEN7079KDah Aircraft LLC · Georgetown, SCN707HJIndustrial Helicopters LLC · Lafayette, LAN707MDEfw Inc · Fort Worth, TXN707MKSch Aviation Inc Trustee · NorfolkN707SJCtrg Aviation Holdings LLC · Lakeway, TXN709ACJbd Enterprises Inc · Englewood, CON710ACJbd Enterprises Inc · Englewood, CON711HLMann Laurence F · San Jose, CAN711KVAa Leasing Lp · Kilauea, HIN711ZWMalmrose Heli Services Inc · North Salt Lake, UTN712CACatalyst Aviation LLC · Hammonton, NJN713BCTimcoaviation LLC · Purvis, MSN716CBCbhelos LLC · Chesapeake, VAN716KVAa Leasing Lp · Lihue, HIN716VLAirwayplanner.Com LLC · Sands Point, NYN7173FFour Creeks Aviation Inc · Visalia, CAN7173SCraig Helicopters Inc · Craig, CON719CBCbhelos LLC · Chesapeake, VAN719KVAa Leasing Lp · Kilauea, HIN721KHBruce Mike · Evadale, TXFirst renewal noticeN721RPRatcliff Dustin · Saltville, VAN722LMNorthwest Helicopters LLC · Olympia, WAN7230TFernandez Rosario Yailin · Imperial, CAN7242NMaverick Jet Leasing Inc · Wilmington, DEN724HKHawkeye Helicopter LLC · Lyndon, KSN7250EAg Air Inc · Oakdale, CAN725MAviation Advantage Inc · Tabor City, NCN727BBDle Corp · Lewes, DEN727JSTrickett Michael W · Washington, DCN727JVCalifornia Helicopter Operations LLC · Santa Rosa, CAN72VVBank Of Utah Trustee · Salt Lake City, UTN734HHHlh Leasing LLC · Wilmington, DEN735CBChesapeake Bay Helicopters Inc · Chesapeake, VAN73AJGreenway Avia Inc · Wilmington, DEN73AMMetroplex Flight Services LLC · Fort Worth, TXN743MHDah Aircraft LLC · Georgetown, SCN744TVU S Helicopters Inc · Marshville, NCN745HAPrivate LLC · Kalispell, MTRegistration ineffective or invalidN74678Southmark Aviation Inc · Hattiesburg, MSN747DMHunter Construction Group Inc · Mooresville, NCN748CBCbhelos LLC · Chesapeake, VAN74AJAerial Control Inc · Brentwood, CAN74FKSt Louis Airmotive LLC · Wilmington, DEN7508PReece Michael · Marathon, FLN753BFAis Construction Equipment · Grand Rapids, MIN75454Realstaff Rocket LLC · Salem, ORN75CWChem Air LLC · Shreveport, LAN75YLinville Manor LLC · Reidsville, NCN760AMAir Services Inc · Minneapolis, KS
Back to AD 2005-10-13