AD 2002-11-05
Registered aircraft · 948
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-11-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-11-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-11-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-11-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.
N209LAWest Valley Aviation Inc · Five Points, CAN211CHRegistered aircraftN212DTThiel Aircare Inc · Chowchilla, CAN212FBAero Spray Inc DBA · Appleton, MNN213BHBighorn Flying Co LLC · Wood River, NEN214RLLassco LLC · Middletown, DEN224CNRegistered aircraftN2254LPhoenix Equipment Lc · Nickerson, KSFirst renewal noticeN226FBLipan Creek Flying Service LLC · Eola, TXN228RGA+ Aviation Services LLC · Garden City, KSN22FKFast Ag Air LLC · Watertown, SDN22WHAeronautical Technologies Inc · Clovis, NMN2306ABlanke Jason F · Mandeville, LAN23618Aerinova Aerial LLC · Mattoon, ILN23649Abernathy Spraying Service Inc · Tipton, OKN23744Van Horne Robert E · Centralia, ILN2393NMid Mo Ag Air LLC · Boonville, MON23WTAeronautical Technologies Inc · Clovis, NMN240DLBlue Earth Flying Service LLC · Blue Earth, MNN240LATwin Cities Aviation Inc · Yuba City, CAN246LAChambers County · Anahuac, TXN247SEThiel Air Care Inc · Chowchilla, CAN257CAHorizon Air LLC · Lumpkin, GAN265FBFarm Brothers Flyers A LLC · Gould, ARN268FBFarm Brothers Flyers A LLC · Gould, ARN271LAA+ Aviation Services LLC · Goodland, KSN272DAAero Spray Inc DBA · Appleton, MNN274ATBoardman Air Service LLC · Henderson, NEN274BMEvergreen Flying Service Inc · Dover, DEN276ATBoardman Air Service LLC · Henderson, NEN278ATBoardman Air Service LLC · Henderson, NEN281DLThisius Flying Service Llp · Wells, MNN281LABoedeker Flying Service East LLC · Childress, TXN288KWFarm Air Inc · Astoria, ILN291DLNorthstar Aero Spray Inc · Clara City, MNN294LARoma Air Corp · Belle Glade, FLN298LAGregs Crop Care Co Inc · Wilbur, WAN299JHJohnson Airspray Inc · Argyle, MNN3011SH & H Flying Co · Finley, TNN3030CWtas LLC · Dyersburg, TNN3030LShannon Agricultural Flying Inc · Clarksdale, MSN3030QFinke Aviation LLC · Charleston, MSN3033HAkbj LLC · Lewes, DEN3038PAgri-Tech Aviation Inc · Indianola, IAN3042SAg Aviation Inc · Muleshoe, TXN3054WMoes Crop Dusting Service Inc · Marysville, CAN3056QPalmer Flying Service Inc · Manito, ILN305LAShores Ag-Air Inc · Corpus Christi, TXN3063GChristmas Flying Service LLC · Shelby, MSN3063YWeaver Flying Service Inc · Quincy, WA
Back to AD 2002-11-05