AD 2002-26-05
Registered aircraft · 502
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-26-05')
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-26-05')
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-26-05') 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-26-05') 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.
N502HCBoyd'S Aviation LLC · Rayville, LAN502HDRosewood Air LLC · Plaucheville, LAN502HFHowze Flying Services LLC · Banquete, TXN502HMMoores Aerial Applicators LLC · Clinton, NCN502HWNeal Aircraft Inc · Slaton, TXN502JAHoppe Air LLC · Beaman, IAN502JDDeterding Jim · Pond Creek, OKN502JFLejeune Aerial Applications LLC · Basile, LAN502JKRoma Air Corp · Belle Glade, FLN502JPAcadian Dusters LLC · Church Point, LAN502JRJerrys Flying Service Inc · Wabbaseka, ARN502JWBear Flying Service Inc · Sicily Island, LAN502KBMeyers Aerial Service LLC · Superior, NEN502KFForest Kevin · Langdon, NDN502KHWillmar Aerial Spraying Inc · Olivia, MNN502KSFoxtrot Air LLC · Highmore, SDN502LCCady Neil DBA · Rock Falls, ILN502LDH & G Farms · Corcoran, CAN502LYR & R Flight Service Inc · Mendota, ILN502MBLepanto Crop Service Inc · Lepanto, ARN502MDRba LLC · Kimberly, IDN502MHWoodley Aerial Leasing LLC · Walnut, ILN502MKGeist Daniel C · Crookston, MNN502MSMid-State Aviation II Inc · Cozad, NEN502MVMidwest Aerial Spraying LLC · Dorchester, NEN502NBWells Fargo Equipment Finance Inc · Clark, SDN502NEWilcox Aerial Applications Inc · Tilden, NEN502NJBretts Spray Service Inc · Onida, SDN502NLBoettcher Aerial Company Inc · Beloit, KSN502NRHoelscher Rodney · San Angelo, TXN502PAPost Rock Aviation Inc · Lincoln, KSN502PBHershey Flying Service Inc · David City, NEN502PVWesterlin Harrington Flying Service Inc · Holdrege, NEN502QDixie Flying Service Inc · Gilliam, LAN502RBDans Flying Service Inc · Crookston, MNN502RCMid-State Avaition II Inc · Cozad, NEN502RER And R Flight Service Inc · Mendota, ILN502RSSwing Wing Inc · Veedersburg, INN502SBGross Flying Service Inc · Larned, KSN502SDTri-County Ag Service Inc · Ipswich, SDN502SEWesterlin Harrington Flying Service Inc · Holdrege, NEN502SMBank Of Utah Trustee · Salt Lake City, UTN502SSSchneider Aerial Inc · Rugby, NDN502TGOld River Applicators LLC · Simmesport, LAN502TRSterling John A · Port Lavaca, TXN502VBRegistered aircraftN502VSValley Spraying Service LLC · Gann Valley, SDN502WDOver And Under Flying Service DBA · Knox, INN502WFBank Of Utah Trustee · Salt Lake City, UTN502XH&G Farms Inc · Corcoran, CA
Back to AD 2002-26-05